About Us

Don Guillett

Oops wrong thread

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message news:...
Try this idea instead
=SUM(U7:OFFSET(U7,0,d3-1))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FLORERO" wrote in message
...
I had already tried that. Thanks.

"Don Guillett" wrote:

WithOUT testing how about newbook.xls

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FLORERO" wrote in message
...
I am working with a workbook in Excel 2003 that has over 40 tabs
(worksheets). Each worksheet is a department report and each
department
has 4
reports. The last report is the one I need to select for each
department
and
copy it into a new workbook. The name of the worksheets to be selected
copied
and pasted is "xxxxx-RSS Upload" where x is the department number. I
was
trying to find a property that could only select the "Upload" part of
the
worksheet name as a common denominator to select multiple worksheets
that
end
with that text string. I started of like this:

Sub Macro3()
Dim ws As Worksheet
For Each ws In Worksheets
If UCase(Right(Trim(ws.Name), 6)) = "UPLOAD" Then
ws.Select
ws.Copy After:=Workbooks("newbook"). _
Worksheets(Workbooks("newbook").Worksheets.Count)
End If
Next ws

End Sub

The Macro stops and gets error '9': Subscript out of range

The debugger directs me to the following line:
ws.Copy After:=Workbooks("newbook"). _
Worksheets(Workbooks("newbook").Worksheets.Count)

If I remove this line the Macro works fine selecting only the tabs i
want,
so I know I am halfway in the right direction. Can anybody come up
with a
solution for this??? Thanks in advance for your help

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select and copy certain tabs using macro	FLORERO	Excel Programming	7	November 29th 07 05:39 PM
Select certain tabs using macro	FLORERO	Excel Programming	5	November 28th 07 10:29 PM
Macro - Copy row and paste on all tabs	masterbaker	Excel Programming	4	July 12th 07 01:45 PM
Macro to copy hidden sheet to front of tabs?	StargateFan[_3_]	Excel Programming	1	October 20th 05 01:47 PM
Select/Copy/Paste in Macro/VBA	Jim Clark	Excel Programming	1	September 1st 04 09:34 AM

Menu

About Us