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?
|