Re: $$Excel-Macros$$ Excude some sheets in macro

2012-02-28 Thread dguillett1
l-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Monday, February 27, 2012 10:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excude some sheets in macro Hi Don and all Yes Don I totally agree that I should know better. But I am t

RE: $$Excel-Macros$$ Excude some sheets in macro

2012-02-28 Thread Asa Rossoff
cros@googlegroups.com] On Behalf Of Cab Boose Sent: Monday, February 27, 2012 10:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excude some sheets in macro Hi Don and all Yes Don I totally agree that I should know better. But I am trying hard to understand everything

Re: $$Excel-Macros$$ Excude some sheets in macro

2012-02-27 Thread dguillett1
You have been doing this awhile and should know better. Anyway. Sub copycorrectsheets() Dim ws As Worksheet For Each ws In Worksheets If ws.Name <> "Summary" _ And ws.Name <> "forms" _ And ws.Name <> "admin" Then ws.Range("G7").CurrentRegion.Copy _ Worksheets("summary").Cells(Rows.Count, "G").End(x