Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions |