View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?