Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Used Range
I have date in the first 50 rows of a worksheet.
If I delete rows 10 through 100 by using either: rows("10:100").select selection.delete or rows("10:100").select selection.clear then I should only have data in the first 9 rows. I have a function that is relying on the used range. I would expect the following to return an address that ends in row 9. However it returns an address that ends in row 100. UsedRange.SpecialCells(xlCellTypeLastCell).Address Any ideas why row 100 is still in the used range??? TIA... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |