Why is the last used cell being used?

  • Thread starter Thread starter Lostguy
  • Start date Start date
L

Lostguy

Hello!

From what I can see, my last used cell is D48. From what Edit>Go
To>Special>Last Cell is telling me, it's AF51.

But when I go to AF51, it is blank, has no conditional formatting, has
no data validation, and has no formulas. So why, is it the "last cell
used"? I can find alot of "Find Last Used Cell" macros, but nothing
that looks at your sheet and lets me know "This is the last used cell
because it contains__________."

??

I appreciate any help with this.

VR/ Lost
 
Excel has a better memory than you--and it doesn't contract that used range
unless you do something special to reset it.

If you've ever entered something in AF51 (or row 51 and column AF), then excel
will remember that cell as the last used cell.

Visit Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html#Unused
For a couple of techniques of resetting that last used cell.
 
Back
Top