Macro Help

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

I am new to the world of macros, especially in 2000. I
need to have a macro that will open a 2nd spreadsheet, and
copy data from one spreadsheet to the newly opened one,
save and then close the 2nd spreadsheet. The problem I'm
having is I want the information from the first form to
copy to the first available row on the 2nd sheet. I've
heard about "lrow" but I don't know how to use it...

Any help would be greatly appreciated...
Thanks!
Andrea
 
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.
 
Back
Top