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





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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>
>
>
>
> 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