Whatever "1row" is it is not part of Excel or
VB. It looks like a variable
someone created in his code.
Anyway, a typical way to find the next empty cell in a column is something
like this:
Set NextCell = Range("A65536").End(xlUp).Offset(1)
for column A. This assumes the column is not full and there is at least one
entry already there.
--
Jim Rech
Excel MVP