Posted to microsoft.public.excel.programming

Edgar Thoemmes[_4_] Edgar Thoemmes[_4_] is offline

external usenet poster

Posts: 16

Delete Sheets Problem

Hi

Why isnt this code working? It is coming up with the 'Type Mismatch' error.

Thanks

Sub DeleteSheets()

For x = 1 To Worksheets.Count
If Worksheets(x).Name < "Menu" Or "Sage Export" Then
Worksheets(x).Delete
End If
Next x

End Sub

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VB Delete Sheets	LJones	Excel Programming	3	July 27th 04 02:18 PM
delete all sheets except...	caroline	Excel Programming	4	May 22nd 04 04:29 PM
Delete Sheets	Jahsonn	Excel Programming	1	April 26th 04 01:42 PM
Delete Sheets	SS[_3_]	Excel Programming	2	February 5th 04 02:37 PM
Delete new sheets?	ianripping[_27_]	Excel Programming	1	January 17th 04 02:14 PM

All times are GMT +1. The time now is 10:24 AM.

About Us

"It's about Microsoft Excel"