I'm just starting to lear to write macros.

If I want to write data the adjacent cell, I can reference it using
.Offset(0,1).

However, if I want to write to Col KL of whatever row I'm in, how do I
combine absolute with relative for VBA (Something similar to $K1)

Any help is appreciated.

---GJCase


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=560891

cells(activecell.row,"k").value=1
or
range("k" & activecell.row).value=1

--
Don Guillett
SalesAid Software

"gjcase" wrote in
message ...

I'm just starting to lear to write macros.

If I want to write data the adjacent cell, I can reference it using
Offset(0,1).

However, if I want to write to Col KL of whatever row I'm in, how do I
combine absolute with relative for VBA (Something similar to $K1)

Any help is appreciated.

---GJCase


--
gjcase
------------------------------------------------------------------------
gjcase's Profile:
http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=560891

Thanks, Don


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=560891

glad to help

--
Don Guillett
SalesAid Software

"gjcase" wrote in
message ...

Thanks, Don


--
gjcase
------------------------------------------------------------------------
gjcase's Profile:
http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=560891