Thread: how do find out the column of the active cell in a macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
  
Posts: 1,090
Default how do find out the column of the active cell in a macro?
One way:
TheCol = ActiveCell.Column
"Neill Lee" <Neill wrote in message
...
I want to find out the column of the presently active cell in a macro in
excel. I want to do this so the macro can test to see if the present cell
is
in a particular column. Can anybody help?


Reply With QuoteReply With Quote