| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange higher than expected
Thanks Tom, this did the trick.
Chris "Tom Ogilvy" wrote: See Debra Dalgleish's FAQ entry on this: http://www.contextures.com/xlfaqApp.html#Unused -- Regards, Tom Ogilvy "ChrisO" wrote: Hello, I have a sheet where I only have cells populated to row 150 and column 12 (L) but: maxrow = Worksheets(sheetname).UsedRange.Rows.Count maxcol = Worksheets(sheetname).UsedRange.Columns.Count reports 5006 and 19 respectively. I have even tried using .Clear, .Borders.LineStyle = xlNone and .Interior.ColorIndex = xlColorIndexNone for rows 151 onwards, but UsedRange still reports the same figures. Can anyone tell me why, and how I can clear rows 151 onwards? The file is bigger than I'd expect so I can believe there is something in these rows but I cannot see what it is or how to get rid of it. Thanks in advance, Chris |
Hybrid Mode
