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