| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get active cell?
Hello,
I'm building a simple search function in my workbook. I have no problem in locating specified text, but I do not know how to 'get' the location of the current cell, I tried: CellMatch = ActiveCell But, alas, this simply assigns the value of the currently selected cell to CellMatch. I want the location, "A2" for example. Thanks in advance Mat. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| set the background color of the current cell(active cell) | New Users to Excel | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
| Sum to active cell | Excel Discussion (Misc queries) | |||
Threaded Mode
