| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active cell position for macro | Excel Worksheet Functions | |||
| Formula to return position of the next Non-blank cell in a column | Excel Worksheet Functions | |||
| Formula to return cell position | Excel Worksheet Functions | |||
| How to I return the position of a selected cell in a range? | Excel Programming | |||
| Active Cell Position Using Go To Or Hyperlink | Excel Programming | |||
Threaded Mode
