If Worksheets("Test") Exists Then Delete It

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 6

If Worksheets("Test") Exists Then Delete It

Hi,

I want to do the above, but just can't work out how to do
it. If anyone has a piece of code that would work, I would
be very grateful.

Exists does not seem to work with the Worsheets.Item
object.

Don.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Excel "Move or Copy" and "Delete" sheet functions	dsiama	Excel Worksheet Functions	1	December 28th 07 01:57 PM
How to delete the char "A" if it exists?	Eric	Excel Discussion (Misc queries)	6	December 3rd 06 06:42 PM
No "Sheet" tab exists on Page Layout. Need to print gridlines.???	Terre	Excel Worksheet Functions	4	September 20th 06 02:04 AM
Delete Row Containing "x" in ColumnA in 2 Worksheets	Ed	Excel Discussion (Misc queries)	1	July 15th 06 05:43 PM
Complex if test program possible? If "value" "value", paste "value" in another cell?	jseabold	Excel Discussion (Misc queries)	1	January 30th 06 10:01 PM

All times are GMT +1. The time now is 12:24 PM.

Menu

About Us