Activate a worksheet and paste / Import a code

  • Thread starter Thread starter Dileep Chandran
  • Start date Start date
D

Dileep Chandran

Hi,

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

Thanks!

-DC
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine 2 columns in a dynamic range into one 7
Rookie Question - Activating Worksheets 2
Code to copy worksheet 5
Need Macro... 8
Select Worksheet Where Data is Pasted 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Error 1004 3
Run Time Error '1004' 1

Back
Top