Different ways to access ListObject Headers???

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

06-07-2012, 06:59 AM

Colin Legg Colin Legg is offline

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

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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

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 03:26 PM.