Microsoft Office Forums - View Single Post - [Solved] Different ways to access ListObject Headers???

Thread: [Solved] Different ways to access ListObject Headers???

View Single Post

Old

06-07-2012, 06:59 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Okay, this will give you the index of the column within the table itself:

Code:

Debug.Print Sheet1.ListObjects("oTable").ListColumns("Header1").Index

This code will give you the column number within the worksheet:

Code:

Debug.Print Sheet1.ListObjects("oTable").ListColumns("Header1").Range.Column

Reply With Quote