Different ways to access ListObject Headers???

tinfanide · #3 06-06-2012, 09:30 AM

Quote:

Originally Posted by Colin Legg

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

Yeah. Just liked the shortened one. The ListObjects.ListColumns. too long.

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