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
on.Copy _
Worksheets("summary").Cells(Rows.Count, "G").End(xlUp)(2)
End If
Next ws
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Cab Boose
Sent: Sunday, February 26, 2012 10:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excude some she
Hi
See attachedI workbook. XL2000
Refer to summary sheet
I am wanting to extract data from some sheets into summary sheet. I can
exclude 1 sheet ok, but when I try to exclude others I get syntax error.
The line of code with problem is:
If Worksheets(k).Name = "summary", "forms", "admin" Then
