Column Headings
 

i = 27
colLetter = Left(cells(1,i).address(0,0),1-(cells(1,i).Column26))

--
Regards,
Tom Ogilvy



"OkieViking" wrote in message
...
In VBA columns are denoted by numbers, but in Excel they are denoted by
letters (i.e. Column A, Column C). Is there a Column property that returns
the Letter instead of the number? Is there another way of getting to that?

Column Headings
 

Thanks again!

"Tom Ogilvy" wrote:

i = 27
colLetter = Left(cells(1,i).address(0,0),1-(cells(1,i).Column26))

--
Regards,
Tom Ogilvy



"OkieViking" wrote in message
...
In VBA columns are denoted by numbers, but in Excel they are denoted by
letters (i.e. Column A, Column C). Is there a Column property that returns
the Letter instead of the number? Is there another way of getting to that?