Different ways to access ListObject Headers???

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Different ways to access ListObject Headers???

FAQ

Thread Tools

Display Modes

06-05-2012, 02:49 PM

Colin Legg Colin Legg is offline

Windows 7 32bit Different ways to access ListObject Headers???

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

You can access it via a ListObject object, for example:

Code:

Worksheets("Sheet1").ListObjects("oTable").ListColumns("Header1").Range.Cells(1).Select

You have to be careful with the [ ] because they are also shorthand for the Evaluate method in VBA. This would also potentially work, but (in my opinion) it is confusing and an ugly piece of code best avoided:

Code:

[oTable[[#Headers],[Header1]]].Select

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need headers on each sheet	Mendopaul	Excel	0	02-21-2012 05:51 PM
Searching A Database Two Ways	skoz55	Excel	3	11-10-2011 01:01 AM
Creative Ways for a year-to-year comparison???	ridonkulous5	Excel	1	03-23-2011 04:49 PM
Access 2007 Upgrade After Initial Install - Access 2003 Won't Remove	wcb	Office	1	01-25-2010 04:08 AM
Help with headers	Bill	Word	0	03-10-2009 05:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:26 PM.