Find/Calculate Active Row

[sTremper]

On my menu I have a "Total" cell for the row I am working on. I don't want to have to update the cell row number each time. How can I have it Vlookup the current active row and calculate it until I move down and start a new row?

tks

 

[jim may]

Something like:

cr = Activecell.row

 

[JoeMo]

On my menu I have a "Total" cell for the row I am working on. I don't want to have to update the cell row number each time. How can I have it Vlookup the current active row and calculate it until I move down and start a new row?

tks

Sub CalcCurrentRow()
Rows(Activecell.Row).Calculate
End Sub

 

[sTremper]

Have not done much (anything) with VBN. I tried watching some videos but couldn't find anything that was my fit.

I am trying to display the value of the active row's "column AB" to my menu cell R2. The row range I am working with is only rows 3-60 in my "Weekly" worksheet. Once I move down and start a new row I would like it's column AB to be highlighted in my menu R2, and so on.