Thread: In macros, an instruction that will return the position of the Active Cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default In macros, an instruction that will return the position of the Active Cell
Hi aca
how can I make it show the position of the Active Cell<
MsgBox ActiveCell.Address
MsgBox ActiveCell.Column
MsgBox ActiveCell.Row
how can I set that position as a Condition; e.g. "If ActiveCell is
B7 Then...." <
If ActiveCell.Address = $B$7 Then ...(be careful with this one, must
have the $'s)
If ActiveCell belongs to Column G Then...<
If ActiveCell.Column = 7 Then...

Ken Johnson

Reply With QuoteReply With Quote