Different ways to access ListObject Headers???

tinfanide · #1 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.

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