VBA Delete blank rows with a formula but has no value

[clazzic]

Hi All,

So my scenario is i have a range e.g. A3: BA1000 that is filled with formulas. the formulas will blank out when there is no value. In all cases all the rows with value will be at the top.
just looking to see if there is a macro that allows me to find all the rows that has no value and delete?

or is there an option where i can just select my range that has a value and not blanks?

thanks in advance

 

[clazzic]

What if its not deleting cells. Just Clearing the contents from those blanks? would that be faster?

 

[svendiamond]

Yes, much

 

[clazzic]

yeah, its much faster than deleting, but its still not instant

 

[svendiamond]

Turn off screen updating, change calculation to manual, then change back at the end.

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

 

[svendiamond]

Wait a minute you're saying you want to clear the contents of rows that have no contents anyway since they're all blanks?? What is the point?