VBA help with Offset

[gjcase]

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

 

[Don Guillett]

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

 

[gjcase]

Thanks, Don

 

[Don Guillett]

glad to help