| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find active cell
New to Excel VBA. The following does not return the current active cell
but returns error 91. Sub Macro1() ' ' Macro1 Macro ' Dim rangeCurrentCell As Range ' rangeCurrentCell = ActiveCell 'more stuff The defn. of ActiveCell is confusing me. All I want is the currently selected in A1 type format. Thanks. Thomas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| Find last cell in a column, Delete its contents and make it active | Excel Worksheet Functions | |||
| Find address of active cell | Excel Worksheet Functions | |||
| copy active cell value,find the pasted value in different worksheet | Excel Worksheet Functions | |||
![Thomas[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
