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.)

worksheets("sheet2").range(activecell.address).val ue = 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.





Maxx wrote:

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.)

--

Dave Peterson

Thak you so much.


"Dave Peterson" wrote in message
...
worksheets("sheet2").range(activecell.address).val ue = 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.





Maxx wrote:

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.)

--

Dave Peterson