Delete Empty Cell With Formula

  • Thread starter Thread starter jackcwood
  • Start date Start date
J

jackcwood

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

also i have locked the cells
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula ques 2
Excel VBA 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Find first empty cell in column 2
Help Writing a SUM Formula 5
Excel formula, sum the value cell and if empty cell left blank 0
Cell shows the last typed text, no matter where it is typed 0
incorrect output of if formula 6

Back
Top