get and put value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

!..:: Enang ::..! - 23 Sep 2005 10:40 GMT

How do I get the value some colomn before (and after) ActiveCell.Value and
put in a cell

ex :
A1 = "UK"
B1 = "US"
C1 = "AU"
D1 = "ID"
E1 = "DE"

The activecell is C1, I want to get the value of colomn A,B,D,E and put in
(let say) AA,BB,DD,EE

thx

Reply to this Message

Bob Phillips - 23 Sep 2005 12:06 GMT

VBA?

Range("AA1").Value = Cells(Activecell.Row,"A").Value

etc.

Signature

HTH

Bob Phillips

> How do I get the value some colomn before (and after) ActiveCell.Value and
> put in a cell
[quoted text clipped - 10 lines]
>
> thx

Reply to this Message

!..:: Enang ::..! - 24 Sep 2005 05:00 GMT

it work!
thank you :)

> VBA?
>
[quoted text clipped - 21 lines]
> >
> > thx

Reply to this Message