Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell Content
Hello, Is there a way that I can delete a cells content without deleting th formula in that cell? Thank -- Altec10 ----------------------------------------------------------------------- Altec101's Profile: http://www.excelforum.com/member.php...fo&userid=3453 View this thread: http://www.excelforum.com/showthread.php?threadid=57077 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell Content
The only thing I can think of is to set the font color to white which will
cause the cell to appear empty. You probably would want to protect the cell to prevent its being ovwewritten. -- Best wishes, Jim "Altec101" wrote: Hello, Is there a way that I can delete a cells content without deleting the formula in that cell? Thanks -- Altec101 ------------------------------------------------------------------------ Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539 View this thread: http://www.excelforum.com/showthread...hreadid=570778 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell Content
no. the cells content is the formula.
-- Regards, Tom Ogilvy "Altec101" wrote: Hello, Is there a way that I can delete a cells content without deleting the formula in that cell? Thanks -- Altec101 ------------------------------------------------------------------------ Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539 View this thread: http://www.excelforum.com/showthread...hreadid=570778 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell Content
Hi Altec
Maybe you can clear the cells that the formula use and have the formula display "" if the cell or cells are empty. What do you want to do exactly ? -- Regards Ron de Bruin http://www.rondebruin.nl "Altec101" wrote in message ... Hello, Is there a way that I can delete a cells content without deleting the formula in that cell? Thanks -- Altec101 ------------------------------------------------------------------------ Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539 View this thread: http://www.excelforum.com/showthread...hreadid=570778 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell Content
Re-write your OLDformula like this:
=IF(A1="","",OLDFormula) and blank out A1 when you want the cell to appear blank. HTH, Bernie MS Excel MVP "Altec101" wrote in message ... Hello, Is there a way that I can delete a cells content without deleting the formula in that cell? Thanks -- Altec101 ------------------------------------------------------------------------ Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539 View this thread: http://www.excelforum.com/showthread...hreadid=570778 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell Content
Perhaps you could convert it to text? -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=570778 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell Content
Thanks guys for all your help. -- Altec101 ------------------------------------------------------------------------ Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539 View this thread: http://www.excelforum.com/showthread...hreadid=570778 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting some content of a cell | Excel Discussion (Misc queries) | |||
Deleting content | Excel Worksheet Functions | |||
Deleting content in a column | Excel Worksheet Functions | |||
deleting content in cells | Excel Programming | |||
Deleting Hyphens or Dashes from multiple cells without deleting the remaining content | Excel Programming |