Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|