copy the value of the activecell on sheet1 to the same address on sheet 2

M

Maxx

How can I copy the value of the activecell on sheet1 to the same address on
sheet 2?

(So if activecell on sheet 1 is B8, macro will copy value to B* on sheet 2.)
 
D

Dave Peterson

worksheets("sheet2").range(activecell.address).value = activecell.value
(where sheet1 is the activesheet.)

Actually, this just "copies" the value.

activecell.copy _
destination:=worksheets("sheet2").range(activecell.address)

Would do the copy|paste.
 
M

Maxx

Thak you so much.


Dave Peterson said:
worksheets("sheet2").range(activecell.address).value = activecell.value
(where sheet1 is the activesheet.)

Actually, this just "copies" the value.

activecell.copy _
destination:=worksheets("sheet2").range(activecell.address)

Would do the copy|paste.
Click to expand...
 

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

ActiveCell on inactive sheet 8
conso macro 0
Excel Applying Code to a Column 0
Return the values in another sheet 3
My code need to go on a diet 10
Add up cell from sheet 1 to show on sheet 2 5
Comparing Cell values in two sheets within the same workbook 10
Excel VBA to move cells to sheet2 based on selection in sheet1 0

Top