| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO STORE CURRENT COLUMN & ROW
I need a current_row() & current_col() function so I can store row / column
where user places cursor. Is there something built in so I can get this info? I need to store row and column info to a variable. TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO STORE CURRENT COLUMN & ROW
Use this
Arow = ActiveCell.Row Acol = ActiveCell.Column -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "tootles" wrote in message news:nR0fb.33094$AH4.17589@lakeread06... I need a current_row() & current_col() function so I can store row / column where user places cursor. Is there something built in so I can get this info? I need to store row and column info to a variable. TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get current row-column? | Excel Discussion (Misc queries) | |||
| store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
| highlight current row/column | Excel Discussion (Misc queries) | |||
| Help! Current Date in a column | Excel Worksheet Functions | |||
| how do I highlight the current row and column | Excel Discussion (Misc queries) | |||
Linear Mode
