| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CurrentRegion less one Row
In code if you are using: set rng = activecell.usedregion, how do you
reduce the usedregion by one row. Would it be usedregion - 1? As an example, the usedregion is A5:G10 and you want to set the range to A6:G10. Would it be: Set rng = activecell.usedregion - 1 TIA Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| currentregion | Excel Discussion (Misc queries) | |||
| CurrentRegion | Excel Programming | |||
| CurrentRegion Selecting | Excel Programming | |||
| CurrentRegion Failure. Please help! | Excel Programming | |||
| CurrentRegion.copy maybe? | Excel Programming | |||
Threaded Mode
