try this
Sub Datacopy()
Sheets("teste").Range(Sheets("teste").Cells(1, 1),
Sheets("teste").Cells(Sheets("teste").Range("a65356").End(xlUp).Row,
3)).Copy
With Sheets("destino")
.Cells(Sheets("destino").Range("a65356").End(xlUp).Row,
1).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues
End With
End Sub
On Wed, Apr 6, 2011 at 10:50 AM, Dave Bonallack
<davebonall...@hotmail.com>wrote:
> Hi Jorge,
> Your workbook didn't contain any macros.
> Regards - Dave
>
> ------------------------------
> Date: Tue, 5 Apr 2011 23:40:56 +0100
> Subject: $$Excel-Macros$$ copy macro error
> From: leote.w...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Hi, can someone please tell what i did wrong, this is my first macro all by
> myself, but it gives me a error, i made a macro where i what to copy sheet
> "teste" to sheet "destino" but without range, so that when i introduce new
> values to column A,B,C and execute the macro it copys all values to destino,
> but it only copys last cell of A :S!can someone see what´s wrong with my
> code?1000 thanks!
>
> Sub Datacopy()
>
> Worksheets("teste").Cells(Rows.Count, "A").End(xlUp).Copy
>
> With Worksheets("destino")
> .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
> Paste:=xlPasteValues
> End With
>
> End Sub
>
> --
>
> ----------------------------------------------------------------------------------
> 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
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com <http://akoul.blogspot.com/>
*akoul*.wordpress.com <http://akoul.wordpress.com/>
My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
P Before printing, think about the environment.
--
----------------------------------------------------------------------------------
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
