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