Hi all thanx in advance
I created a macro to create a new sheet and clone cells from an older sheet
like this
='Sheet1'!B1
then the macro does autofill until row 2000 the reason of doing that is
because sheet1 for example is designed to hold info until that no. of cells
and I want to sort only those columns copied to that sheet, but the problem
is when doing sort with autofilter on, all the empty cells which contains a
value but is not used because on the older sheet this cell is empty (but on
this sheet it shows a zero 0) goes to the top,

My question is how do I delete all the unused cells with the formulas?

Please respond as quickly as possible Thanx!

please respond as quicly sa possible Thanx