Thread: how do find out the column of the active cell in a macro?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Neill Lee[_2_] Neill Lee[_2_] is offline
external usenet poster
  
Posts: 2
Default how do find out the column of the active cell in a macro?
Thank You! It works!!!

"Jim Thomlinson" wrote:

HTH

MsgBox ActiveCell.Column

"Neill Lee" wrote:

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