Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good morning, all,
The last entry in my worksheet is in row 15 yet activesheet.usedrange.rows.count reports 16 - or whatever the lowest entry is in the worksheet+1 Another worksheet in the same workbook using the same code retruns the correct value. I tried deleting all the rows below the last entry, to eliminate the possibility of spaces etc, but to no avail - does anyone have any ideas as to what might be going wrong? Thanks in advance Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Real Value of .UsedRange.Rows.Count | Excel Worksheet Functions | |||
UsedRange Count for each column | Excel Programming | |||
Wrong result returned by UsedRange.Rows.Count | Excel Programming | |||
Problem with UsedRange.Rows.Count | Excel Programming | |||
UsedRange problem | Excel Programming |