Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange?? problem
Hi
Using this on wbooks (from another source): realLastRow = .Cells.Find("*", .Range("A1"), , , xlByRows, xlPrevious).Row realLastColumn = .Cells.Find("*", .Range("A1"), , , xlByColumns, xlPrevious).Column Gives realLastRow = 98 and realLastColumn = S Debug.Print Sheets(1).UsedRange.Address = $D$7:$D$13 But Ctrl + Shift + End goes to AF50918. This has a serious effect on VBA processing time. 'Processing' involves copy ,paste, find, delete, replace functionality. What does AF50918 represent? What is the fastest possible way of removing this large unwanted area before processing the real data? T.I.A Geoff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
usedRange problem | Excel Programming | |||
Excel VBA - UsedRange problem | Excel Programming | |||
Problem with UsedRange.Rows.Count | Excel Programming | |||
UsedRange problem | Excel Programming | |||
UsedRange problem | Excel Programming |