Thanks Rakesh,
as I would like to get the copy range changed depending on the
variable I set in the macro. Actually, the code I wrote is something
like below
x = worksheetfunction.counta(worksheets("Sheet1").range("a:a"))
worksheets("Sheet1").range(cells(3,1),cells(x,1)).copy ....
.
.
Sorry I am new in VBA so what I wrote may sound silly and I do know it
should have tons of better methods, would you please share it to me?
On 6月29日, 上午12時03分, Rakesh Joshi <rakesh.ri...@gmail.com> wrote:
> *instead of : you should use , while using cells in range reference*
>
>
>
>
>
>
>
>
>
> On Tue, Jun 28, 2011 at 6:12 PM, Ming <mingtam...@gmail.com> wrote:
> > 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/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
>
> --
> Rakesh Joshi
--
----------------------------------------------------------------------------------
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
