Thanks Daniel,
Sorry I missed this in the post but actually I wrote this in one line
in the macro, but it doesn't work. The book tells me I shouldn't need
to activate the worksheet by indicating worksheets("XXX") in the code.
I believe I should have interpreted sth wrong, would you please point
this out.
** I have checked the "help" in VBA for copy but it doesn't point me
to the right direction... as I thought whether copy is function need
to activate the sheet to perform,
On 6月29日, 上午12時10分, "Daniel" <dcolarde...@free.fr> wrote:
> Hi,
>
> worksheets("sheet1").range(cells(x,1):cells(x,6).copy
> worksheets("sheet2").range(cells(y,1),cells(y,6))
>
> is one same line so you have to add an underscore mark :
>
> worksheets("sheet1").range(cells(x,1):cells(x,6).copy _
> worksheets("sheet2").range(cells(y,1),cells(y,6))
>
> Regards.
> Daniel
>
> -----Message d'origine-----
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part de Ming
> Envoyé : mardi 28 juin 2011 14:42
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ Question on VBA
>
> Hi all,
>
> I have written below syntax but got an error but I can't figure out why
>
> worksheets("sheet1").range(cells(x,1):cells(x,6).copy
> worksheets("sheet2").range(cells(y,1),cells(y,6))
>
> However, I can do it if I seperate it as follows:
>
> worksheets("sheet1").range(cells(x,1):cells(x,6).copy
> worksheets("sheet2").activate
> worksheets("sheet2").range(cells(y,1),cells(y,6)).pastespecial
>
> Would you please let us know what's the problem?
>
> --
> --------------------------------------------------------------------------- -
> ------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip2. 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.com5. 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
> linkhttp://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
