Posted to microsoft.public.excel.programming

Angus

external usenet poster

Posts: 81

Delete sheets with "@"

I have a VBA to "show pages" by email address at a pivot table. Then the
program calls a Sub to email the sheets with sheet name "@". But how to
delete those sheets with "@" after sending the emails?

Sub PagebyUser()
Sheets("PivotData").Select
ActiveSheet.PivotTables("PivotTable1").ShowPages PageField:="Email"
Call SendbyUser
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
Delete all sheets in workbook that contain "Dump" in the name	Porr via OfficeKB.com	Excel Worksheet Functions	2	May 19th 10 10:25 PM
How do I delete Sheets if "Delete" is greyed out?	carriemca	Excel Discussion (Misc queries)	1	April 10th 06 05:31 PM
Supress "delete sheets" warning	Hari[_3_]	Excel Programming	0	September 14th 04 09:02 PM
Supress "delete sheets" warning	Ron de Bruin	Excel Programming	0	September 14th 04 08:59 PM
How2 Delete "Not exist" charts/sheets?	fatfish[_4_]	Excel Programming	4	July 22nd 04 02:17 PM

All times are GMT +1. The time now is 03:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us