Thread: How do I get the column of a cell?
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 How do I get the column of a cell?
Range("B5").Select
? Left(ActiveCell.Columns.Address(, ColumnAbsolute:=False), 1)
B
Range("BB5").Select
? Left(ActiveCell.Columns.Address(, ColumnAbsolute:=False), 1)
B

--
Regards,
Tom Ogilvy

"debartsa" wrote in message
...
Thanks Carim,

I'll give it a try!


"Carim" wrote in message
oups.com...

Hi Sam,

Why don't you just add Left(x,1)
Left(Target.Columns.Address(, ColumnAbsolute:=False), 1)

HTH
Cheers
Carim





Reply With QuoteReply With Quote