Value of the next row

R

Ron de Bruin

Hi

This will give you the value of the Cell in B in the next row

MsgBox Cells(ActiveCell.Row + 1, "B").Value
 
Top