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
Need Help with a VBA subroutine 0
VBA for Dependents shortcut menu 0
VBA code for for telnet 1
Add up cell from sheet 1 to show on sheet 2 5
Copy Array to Array, how to and should I? 13
Clean this select case code up a bit. 2
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Top