Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last used cell
Hi Group,
I am using version 2003. Prior to this version, when I deleated rows at the bottom of the used range, it changed the bottom most used range ie. if last used cell was say W100 and I delated rows 80 to 100, a new last used range was created and would be row 80. This does not seem to be happening in this newer version. This was only allowed if the range was deleted using code, not simply deleting the rows in a worksheet with out code. Not exactly new to this, but has something changed with 2003? Or maybe a new required perameter or setting? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |