, August 30, 2013 12:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy data to next empty row
Hi,
Thank you for your quick reply.
I'm sorry if my question wasn't clear.
What I wanted to find is the next empty row in the first workbook in the
range A37:
you.
DanJ
From: Ravi Kumar
To: excel-macros@googlegroups.com
Sent: Friday, August 30, 2013 2:24 PM
Subject: RE: $$Excel-Macros$$ Copy data to next empty row
Hi,
Find out the last row of third workbook/sheet,
Workbooks("book3").Activate
Worksheets(“sheet3”).activ
try below code
i = WorksheetFunction.CountA(Range("a:a")) + 1
Range("a" & i).Select
.
Enjoy
Team XLS
On Fri, Aug 30, 2013 at 10:09 AM, DanJ wrote:
> Dear Experts,
>
> I have a range, * A37:A115,* in my first (1st) workbook where I copy
> and paste data from my seco
glegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of DanJ
Sent: Friday, August 30, 2013 10:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Copy data to next empty row
Dear Experts,
I have a range, A37:A115, in my first (1st) workbook where I copy and
paste data
Dear Experts,
I have a range, * A37:A115,* in my first (1st) workbook where I copy and
paste data from my second and third workbook, respectively.
Since the number of rows to be copied from the *second workbook* vary
daily, the next empty row in range *A37:A115* of the first workbook
change
