Formua - Count Items in Data Sheet Absolute Reference

[SteveOranjin]

Hello, I have been using the below formula. But everytime I clear the sheet (I use a delete vba to clear the sheet) the count stops working and I have to re-add the reference.

=IF(COUNTA(#REF!)=0,"No Products",COUNTA(#REF!))

Anyone out there who can help me?

Steve

 

[Joe4]

How exactly are you clearing the sheet?
Are you deleting the rows, or just deleting the contents?
What you describe I commonly see when rows are deleted. Try just clearing the contents instead.