how about:

Sheets("sheet2").Range("A2").Copy
Sheets("sheet1").Range("A1").PasteSpecial Paste:=xlPasteValues


On 6 Mar, 21:16, Maria wrote:
Hi Bernd again,

I was quick to say thanks before I have one more question for you...

Let's say I wanted A1 to copy what is in A2 of Sheet 2 in the same workbook,
how would I do that? *

I tried sheet2!A2 *but that did not seem to work.

Thanks again for you help, your great!
-Maria



"Maria" wrote:
Hi Bernd!!!!!!!

Thank you so much for the quick reply, it worked great!
-maria

"Bernd P" wrote:

Hello Maria,

Private Sub CommandButton1_Click()
Range("A1").Formula = Range("A2").value
End Sub

Regards,
Bernd- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -