View Single Post
 
Old 06-05-2012, 02:49 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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
Reply With Quote