Hi there,

I'm fairly a novice at excel vba but im trying to understand how to perform the following.

I would like to run a sub routine that would perform an action on the relative cells for the cell that is passed to the sub, such as:

Public Sub exampRoutine(thisCell As cell)

cellRow = thisCell.row

Cells(cellRow, 2).Value = "value in column B"
Cells(cellRow, 3).Value = "value in column C"

End Sub
Apologies for the basic errors here, but would anyone have any advice as to how to perform such action or a recommendation for a good tutorial covering this.

Any help or advice greatly appreciated.

Cheers

Noel