| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range selection code in a macro
Below is code I wrote to select multiple rows creating a single range
Sheets("Givens").Activat Rows("22:22").Selec Range(Selection, Selection.End(xlDown)).Selec To get me the correct range I need a set of instruction to modify the above range by decreasing by one row from the bottom of the selection. My attempt was for the 4th instruction "Range(Selection, Selection.xlUp).Select" but unfortunately for me it's an improper syntax Please help Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code User Range Selection | Excel Discussion (Misc queries) | |||
| Sumeif macro with range selection | Excel Discussion (Misc queries) | |||
| Macro Range Selection | Excel Discussion (Misc queries) | |||
| macro code to get dynamic range | Excel Discussion (Misc queries) | |||
| macro code to sort a range | Excel Discussion (Misc queries) | |||
Threaded Mode
