Reset Excel Usedrange not working

[AbdulkareemAlhassni]

Hey guys,

i have been trying to reset my excel range after using clear content but everytime i use it the range stays the same.

anyone have an idea how to force the range to get back to "Used range" after " clearing Content "

i have used CTRL + END, yet all cells are blank and nothing inbetween the start and the end, am sure of it.

currently am using the below code

Activesheet.usedrange

and it doesnt seem to work

anyone have an idea ?

 

[AbdulkareemAlhassni]

I've never used .SpecialCells(xlCellTypeLastCell) as, early on in my quest to learn VBA for Excel, I read several reports that it is not reliable. I'm disappointed now to learn that UsedRange may not be entirely reliable either. I use it quite often to respond to posts that provide too little information on layout.

So, i should use .clear for all the blank rows to get my last data point updated when pressing CTRL+END

correct ?

 

[Fluff]

Best bet is to try it & see what happens.