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
Bookmarks