RE: $$Excel-Macros$$ Copy data to next empty row

, 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:

Re: $$Excel-Macros$$ Copy data to next empty row

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

Re: $$Excel-Macros$$ Copy data to next empty row

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

RE: $$Excel-Macros$$ Copy data to next empty row

Hi, Find out the last row of third workbook/sheet, Workbooks("book3").Activate Worksheets("sheet3").activate Finalrow = cells(rows.count,1).end(xlup).row Range("A"&finalrow+1).select Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegrou