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

tinfanide · 06-07-2012, 07:05 AM

Quote:

Originally Posted by Colin Legg

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

Yes, thanks for telling me the difference between .Index and .Range.Column.