Leave the Cell unchanged

  • Thread starter Thread starter Gerrym
  • Start date Start date
G

Gerrym

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
 
=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)
 
If Range("A1").Value = "OK" then
Range("B9").Copy Destination:=Activecell
End If
 
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

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
VBA set thick borders around non empty cells in range 0
Make a maro run upon leaving a cell 0
Paste a range and shifting away existing data 1
Circular Reference 3
Cell shows the last typed text, no matter where it is typed 0
Cells with varying number of lines 1
Disable Clear DContents command in excel - vba code?? 3

Back
Top