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:
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.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
Any help or advice greatly appreciated.
Cheers
Noel
Bookmarks