This will get you the row number of the last cell in column B with data
lastCell = Sheets("sheet1").Cells(Rows.Count, "B").End(xlUp).Row
lastcell + 1 of course would get you the first blank
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Pete" wrote:

Hi - really need a macro that allows users to go to the next blank row
(column B) and copy formulas into next row - where they enter new data.
Without a macro, I can use CTRL+END...
Any advice would be greatly appreciated, thanks in advance!