1048576 Rows

[NathanW]

Hello,

Really not sure what is happening, my excel sheet says (through the vba code ActiveSheet.UsedRange.Rows.Count) that my last used row is the row 1048576. I have selected all beyond the scope of what I'm actually using, selected 'clear content', and it still says my last used row is 1048576. I even saved the document and quit, re-opened the 5 thousand some kb file, and it still has not changed the last used row. I am so confused... Please help!

 

[Jonmo1]

Instead of 'Clear Contents'... Try RightClick - Delete
Then Save/Close/Reopen


NOT press delete key on keyboard - that's the same as clear contents.

 

[NathanW]

Had tried that too and it said it was too much to do all at once and that I needed to select a smaller range... But, no idea what I did, but it works now actually =P Thanks tho! I appreciate the quick response!