Copy using Macros JorgeAE <JorgeAE.2414rr[ at ]news.excelbanter.com> 02.03.2006 05:03:46 I am designing a spreadsheet using macros in which I want to copy a range of cells from one sheet and paste to another. I am able to do that part but what I want to do is to find the way that the macro recognizes the first set of cells is already with data then should paste to the next one. I will appreciate any suggestion. -- JorgeAE

Re: Copy using Macros "Paul B" <to_much_spam_to_list[ at ]nospam.com> 02.03.2006 11:52:56 JorgeAE, This will select the cell below the last cell with data in column A, is that what you need? Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "JorgeAE" <JorgeAE.2414rr[ at ]news.excelbanter.com> wrote in message news:JorgeAE.2414rr[ at ]news.excelbanter.com... [Quoted Text] > > I am designing a spreadsheet using macros in which I want to copy a > range of cells from one sheet and paste to another. I am able to do > that part but what I want to do is to find the way that the macro > recognizes the first set of cells is already with data then should > paste to the next one. I will appreciate any suggestion. > > > -- > JorgeAE