Delete Empty Cell With Formula
 

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

Delete Empty Cell With Formula
 

On 26 Jan, 12:19, wrote:
I need a macro to delete formulas within a cell when the answer to the
formula gives an emtpy cell.
Any ideas ?

also i have locked the cells

Delete Empty Cell With Formula
 

On 26 Jan, 12:49, wrote:
On 26 Jan, 12:19, wrote:

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

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 Richardson
http://teachr.blogspot.com

Delete Empty Cell With Formula
 

On 26 Jan, 14:46, Matt Richardson wrote:
On 26 Jan, 12:49, wrote:

On 26 Jan, 12:19, wrote:

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

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

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

Delete Empty Cell With Formula
 

On 26 Jan, 14:46, Matt Richardson wrote:
On 26 Jan, 12:49, wrote:

On 26 Jan, 12:19, wrote:

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

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

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