| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting simple range relative to the active cell.
I need to have my macro select the 9 cells starting with the active cell in
column B and extending 8 cells to the right. I am doing this as a custom "copy range" funtion in a macro. I do not want an absolute reference for the range. It should be relative to any ACTIVE cell in column B. If there is no ACTIVE cell in column B, then I would like to return an error message "Wrong Column Selected" with and "O.K." button. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Range in non-active sheet | Excel Programming | |||
| Range selecting in non-active workbook | Excel Programming | |||
| Selecting an active cell | Excel Programming | |||
| Specifying cell reference relative to active cell | Excel Programming | |||
| selecting a cell relative to activecell in an excel macro | Excel Programming | |||
Threaded Mode
