| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Leave the Cell unchanged
I have a formula which chacks the contents of a cell, if
it is ok I want to leave it otherwise I want to copy the contents of another cell into the active cell. How do I do this |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Leave the Cell unchanged
=IF(A1="OK","",B 1)
but this is caveated with the fact that it cannot go into A1, as you can't test itself. -- HTH RP (remove nothere from the email address if mailing direct) "Gerrym" wrote in message ... I have a formula which chacks the contents of a cell, if it is ok I want to leave it otherwise I want to copy the contents of another cell into the active cell. How do I do this |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Leave the Cell unchanged
If Range("A1").Value = "OK" then
Range("B9").Copy Destination:=Activecell End If -- Regards, Tom Ogilvy "Gerrym" wrote in message ... I have a formula which chacks the contents of a cell, if it is ok I want to leave it otherwise I want to copy the contents of another cell into the active cell. How do I do this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 - How to keep the formulas unchanged ? | Excel Discussion (Misc queries) | |||
| How to keep a cell ref in formula unchanged when the ref cell move | Excel Discussion (Misc queries) | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Need IF statement that leaves value unchanged | Excel Worksheet Functions | |||
| Need IF statement that leaves value unchanged | Excel Worksheet Functions | |||
Linear Mode
