Bernd P, I need you again!
 

Hi Bernd,

I wrote this as a reply on the other thread but I am not sure you will see
it so I wanted to make sure you did. Thank you so much for the simple range
code you gave me (it's from the "macro code question" thread you answered
before.

But I have one more question for you...

Let's say I wanted to press a button that has cell A1 of sheet 1 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

Bernd P, I need you again!
 

Hi

This should do it:

Sheets("Sheet2").Range("A2")

Regards,
Per

"Maria" skrev i meddelelsen
...
Hi Bernd,

I wrote this as a reply on the other thread but I am not sure you will see
it so I wanted to make sure you did. Thank you so much for the simple
range
code you gave me (it's from the "macro code question" thread you answered
before.

But I have one more question for you...

Let's say I wanted to press a button that has cell A1 of sheet 1 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

Bernd P, I need you again!
 

Bingo!! Thanks so much!!!!!

"Per Jessen" wrote:

Hi

This should do it:

Sheets("Sheet2").Range("A2")

Regards,
Per

"Maria" skrev i meddelelsen
...
Hi Bernd,

I wrote this as a reply on the other thread but I am not sure you will see
it so I wanted to make sure you did. Thank you so much for the simple
range
code you gave me (it's from the "macro code question" thread you answered
before.

But I have one more question for you...

Let's say I wanted to press a button that has cell A1 of sheet 1 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