Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - UsedRange problem
Hello Everybody !
Please help me with UsedRange property. I have a spreadsheet for which I need to know the last used row but get a wrong result every time I run the macro. I use this line: Worksheets(i).UsedRange.Rows.Count which returns 434 but in reality are 343. I tried also with Worksheets(1).Cells.SpecialCells(xlCellTypeLastCel l).Row and the problem persists. Any help ? Thank you Catali -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 BUG UsedRange/LastCell differences with Excel2003. | Excel Discussion (Misc queries) | |||
Problem with UsedRange.Rows.Count | Excel Programming | |||
UsedRange problem | Excel Programming | |||
Help - How do I reset usedrange in excel 2000 | Excel Programming | |||
UsedRange problem | Excel Programming |