| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting wrong last cell when using usedrange in macro in Excel
I've been told that using ActiveSheet.UsedRange will reset the special cell LastCell after deleting from a sheet, but Excel says the last cell is at Y102 when it should be Y10. There is nothing on row 102 at all. What's happening? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 has wrong timing using the worksheet_change macro | Excel Worksheet Functions | |||
| cell to cell multiplications wrong in Excel (28.22 x 27=761.90) | Excel Discussion (Misc queries) | |||
| Wrong result returned by UsedRange.Rows.Count | Excel Programming | |||
| Macro selecting wrong cell range | Excel Programming | |||
| Excel VBA - UsedRange problem | Excel Programming | |||
Threaded Mode
