Hi,

Is there any way to use VBA to return the value of the next row?

Thanks


--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile: http://www.excelforum.com/member.php...o&userid=30818
View this thread: http://www.excelforum.com/showthread...hreadid=506801

Hi

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

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"SusieQ" wrote in message
...

Hi,

Is there any way to use VBA to return the value of the next row?

Thanks


--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile: http://www.excelforum.com/member.php...o&userid=30818
View this thread: http://www.excelforum.com/showthread...hreadid=506801