Activate a worksheet and paste / Import a code
 

Hi,

can anyone help me in getting a macro which can activate a worksheet
and paste a code into the worksheet?

Thanks!

-DC

Activate a worksheet and paste / Import a code
 

Worksheets("Sheet2").Range("H10").Value =
Worksheets("Sheet1").Range("A1").Value


copies Sheet1!A1 to Sheet2!H10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dileep Chandran" wrote in message
oups.com...
Hi,

can anyone help me in getting a macro which can activate a worksheet
and paste a code into the worksheet?

Thanks!

-DC