Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 -Range
If the Range is $E$10: $E$20 and named Fred how does one select the
Range omitting the first cell in the range. If that can be done how does one omit the first and last cell in the range. The reason for asking is that I am trying to avoid breaking the macro when it is necessary to insert or delete rows. I wish to insert information in the cells excluding the first and last. TIA -- ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format range set-up in Excel 2000 | Excel Worksheet Functions | |||
allow users to edit a range in excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
Excel 2000 VBA - Selecting populated range | Excel Programming | |||
SOS:Know Deleted/Inserted Range in Excel 97/2000 | Excel Programming |