| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| Delete empty rows with cell type 2 | Excel Discussion (Misc queries) | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Can I empty the cell who has formula in it | Excel Worksheet Functions | |||
Linear Mode
