Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread dguillett1
inal Message- From: Eddie Sent: Thursday, November 03, 2011 11:46 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet) This looks good but gettin a run time error 1004! On Nov 3, 4:36 pm, "dguillett1" wrote: Sub cc() Sheets

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread Eddie
:l6").Copy  cells(activecell.row,”f”) > > > > > end sub > > > > > > Don Guillett > > > > > SalesAid Software > > > > > dguille...@gmail.com > > > > > > From: Sam Mathai Chacko > > > > > Sent: Thursd

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread Sam Mathai Chacko
m, "dguillett1" wrote: > > > > Sub cc() > > > >Sheets("start").Range("h6:l6").Copy cells(activecell.row,”f”) > > > > end sub > > > > > > Don Guillett > > > > SalesAid Software > > > > dguill

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread Eddie
Range("h6:l6").Copy  cells(activecell.row,”f”) > > > end sub > > > > Don Guillett > > > SalesAid Software > > > dguille...@gmail.com > > > > From: Sam Mathai Chacko > > > Sent: Thursday, November 03, 2011 11:18 A

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread Sam Mathai Chacko
m: Sam Mathai Chacko > > Sent: Thursday, November 03, 2011 11:18 AM > > To: excel-macros@googlegroups.com > > Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet) > > > > Sub PasteStat() > > > >Sheets("start").Range("h6:

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread Eddie
gt; From: Sam Mathai Chacko > Sent: Thursday, November 03, 2011 11:18 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet) > > Sub PasteStat() > >    Sheets("start").Range("h6:l6").Copy Sheets("

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread Eddie
Thanks, However, can you automate this so I dont have to edit the sheet number everytime i use a differnt sheet? On Nov 3, 4:17 pm, ashish koul wrote: > replace sheet1 with ur  Sheet30 in the ur code like > > Sheets("Sheet30").Select > > > > > > On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote: > >

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread dguillett1
Sub cc() Sheets("start").Range("h6:l6").Copy cells(activecell.row,”f”) end sub Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Thursday, November 03, 2011 11:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy a

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread Sam Mathai Chacko
Sub PasteStat() Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" & Selection.Row) End Sub Regards, Sam Mathai Chacko On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote: > > Sub PasteStat() > >Sheets("start").Select >Range("h6:l6").Select >Selection.Copy >Sheets("She

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

2011-11-03 Thread ashish koul
replace sheet1 with ur Sheet30 in the ur code like Sheets("Sheet30").Select On Thu, Nov 3, 2011 at 9:25 PM, Eddie wrote: > > Sub PasteStat() > >Sheets("start").Select >Range("h6:l6").Select >Selection.Copy >Sheets("Sheet1").Select >Range("f" & Selection.Row).Select >A