Delete Empty Cell With Formula

J

jackcwood

I need a macro to delete formulas within a cell when the answer to the
formula gives an emtpy cell.
Any ideas ?
 
J

jackcwood

When you say you have locked the cells, am I correct in assuming that
you've also protected the worksheet/workbook also?

Regards,
Matt Richardsonhttp://teachr.blogspot.com
Click to expand...

Thanks matt I have selected my cells with formulas & locked them, then
I protected workbook enabaling unlocked cells to be accessible to the
user.
now i need to run a script to delete any of the cells not populated in
the locked area. I may just go for a unprotect sheet then copy paste
special (values) script , lock workbook & save as & add a button for
the user Thinking about it .. unless you have a simpler idea

cheers

jack
 
J

jackcwood

When you say you have locked the cells, am I correct in assuming that
you've also protected the worksheet/workbook also?

Regards,
Matt Richardsonhttp://teachr.blogspot.com
Click to expand...

Thanks matt I have selected my cells with formulas & locked them, then
I protected workbook enabaling unlocked cells to be accessible to the
user.
now i need to run a script to delete any of the cells not populated in
the locked area. I may just go for a unprotect sheet then copy paste
special (values) script , lock workbook & save as & add a button for
the user Thinking about it .. unless you have a simpler idea

cheers

jack
 
Top