View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LiAD LiAD is offline
external usenet poster
 
Posts: 386
Default Delete formula if....

Hi,

In a workboook of 15 sheets I have a lot of cells with formulas that will
return either useful data (numerical values or text) or nothing ("").

What sub could I use to get excel to check all of the sheets and delete the
formulas from cells that =""? All other cells need left as they are.

Thankyou
LiAD