Copy and Replace

[komark]

Hi,
I need to copy a cell and paste it on the other. I need to write a vba code for that.
Can anyone help?

 

[SkipVought]

komark,

Turn on your macro recorder and have at it.

Post back with your code if you need help cleaning it up and generalizing it.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[komark]

Skip,
THank you for your help.
How do I compare two cells. Suppose I have two cells C1 and C2. If C1 not equals C2, I want to put out a warning message.

Your help is greatly appreciated.

 

[PHV]

If [C1] <> [C2] Then MsgBox "C1 not equals C2"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Gavona]

Conditional Formatting could change the colour of the background or foreground to highlight the issue. Or you could conditional format a third cell containing the error message. Text colour white unless condition met.

Or use an if statement in VBA (If Range("a1").value<>range("a2").value....to display a message box

Thanks,

Gavin

 

[komark]

Thank you all for your help.
I am able to get the code running