Thread: Macro Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Macro Help

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