Different ways to access ListObject Headers???

Microsoft Office Forums

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

Prev

Previous Post

Next Post

Next

#1

Old

06-05-2012, 10:00 AM

tinfanide

tinfanide is offline

Different ways to access ListObject Headers???

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

Different ways to access ListObject Headers???

Office 2010 32bit

Expert

Different ways to access ListObject Headers???

Join Date: Aug 2011

Posts: 312

tinfanide is on a distinguished road

Default

Different ways to access ListObject Headers???

In VBA,
I know we can do things like:

Code:

Range("oTable[header1]').Select

to access a ListObject Header
But how about

Code:

[oTable].Select
''' anything like this???
[oTable["header1"]].Select ''' return error

Just wondering (not necessarily a matter at all) if there's a simpler way to access a range in a ListObject.

Reply With Quote

« 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 06:49 PM.