VBA Code to move from active cell to a defined column in same ro

[Atrain18wi]

I am an novice when it comes to VBA and new to the forum.

Can someone help me with a code to offset to a cel in a defined column, say column c, within the same row as the active cell?

Thanks

 

[Bong]

cells(activecell.row,3)

_________________
Bob Rashkin

 

[PHV]

You wanted something like this ?
ActiveSheet.Cells(ActiveCell.Row, 3)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Atrain18wi]

The code works perfect, Thanks