| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting all cells using macro
I need to be able to select a range of cells from the first (A1) to the last
active cell. I know there is a Go To.... / Special Cells option but I need a statement to do this that I can use in a macro. If possible I would like to give this a name (eg-"All_Active_Cells" so that I can reference it easily in the macro. Thanks Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use macro to edit data in Excel cells | Excel Discussion (Misc queries) | |||
| selecting cells which contain formulas but return blanks | Excel Discussion (Misc queries) | |||
| Macro, Copy Selected Cells Down a Column | Excel Discussion (Misc queries) | |||
| Copy Selected cells down a row with macro | Excel Discussion (Misc queries) | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
Threaded Mode
