- Joined
- May 6, 2011
- Messages
- 13
- Reaction score
- 0
Hi, I have looked everywhere and cannot seem to find an answer to this question.
I need to be able to copy a range to another cell in another sheet, but everytime I use this bit of code, the spreadsheet seems to muck up and close (it seems to switch between the 2 tabs at ultra fast speeds and then close).
this is my code:
I have also tried:
The above extracts of code do not seem to work as it should so please help.
Much appreciated, Cuddihy2k7
I need to be able to copy a range to another cell in another sheet, but everytime I use this bit of code, the spreadsheet seems to muck up and close (it seems to switch between the 2 tabs at ultra fast speeds and then close).
this is my code:
Code:
If Range("C2").Value > "" then
Range("C2").Copy
Sheets("Step 2").Activate
Range("C2").PasteSpecial
End if
I have also tried:
Code:
If Range("C2").Value > "" then
Sheets("Step 2").Range("C2").Value = Sheets("Step 1").Range("C2")
End if
Much appreciated, Cuddihy2k7