Re: $$Excel-Macros$$ Question on VBA

; > > > > > > On Tue, Jun 28, 2011 at 6:12 PM, Ming 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("

Re: $$Excel-Macros$$ Question on VBA

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

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