God bless you! That got it! Thanks so much!!!
On May 6, 1:53 am, Deepak Pal Singh <deepaktheind...@gmail.com> wrote:
> Hi Bob,
>
> I'm sorry bro, I didn't understand your problem completely...
> There is a minor problem with the code that you"ve written.. If you copy the
> complete column then you can paste it only from row no 1 of the worksheet.
>
> So instead of copying the complete column you just need to copy those rows
> till you data exist..
>
> Like you're copying Data from Sheet1 and want to paste it on sheet "Customer
> Record" than you can write the following code...
>
> Sub Copy_Data()
> Dim LastRow As Long
>
> LastRow=Sheet1.Range("A60000").End(xlUp).Row
> Sheet1.Range("A1:E" & LastRow).Copy
>
> Sheets("Customer Record").Range("A60000").End(xlUp).Offset(1,0).PasteSpecial
> Paste:=xlPasteAll
> Application.CutCopyMode=False
>
> End Sub
>
> Thanks
> Deepak
>
> On Fri, May 6, 2011 at 10:56 AM, NOORAIN ANSARI
> <noorain.ans...@gmail.com>wrote:
>
>
>
>
>
> > ---------- Forwarded message ----------
> > From: Bob <bobandrich...@comcast.net>
> > Date: Fri, May 6, 2011 at 5:22 AM
> > Subject: $$Excel-Macros$$ Copy & Paste next blank row
> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
>
> > I'm sorry , Still having trouble with copy on next available blank
> > row. If I record a macro it's:
> > Columns("A:E").Select
> > Selection.Copy
> > Sheets("Customer Record").*Range("a65356").End(xlUp).Offset(1,
> > 0).Select
> > *
> > ActiveSheet.Paste
> > I want to keep what I have already copied. How do I make it go to the
> > next available blank row.
> > Thanks in Advance.
>
> > --
>
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> > --
> > Thanks & regards,
> > Noorain Ansari
>
> > --
>
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
