LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 124
Default Deleting a sheet via code

Hi
I need to run code that checks all of the worksheets with the name " AC
Details" in my activeworkbook (there can be many sheets with this name for
ex: AC Details (2), AC Details (3) and so on...) to see if any data has
been entered into cells F9:BH1000.
If no data has been entered into those cells, then I need the code to ask
the user if they want to delete the sheet, and if they say yes...then delete
the sheet..
if they say no..then do not delete the sheet.

If the code finds that data has been entered into those cells (F9:BH1000)..
then I need the code to not delete the sheet (or do nothing).

Any help in doing this woud be greatly appreciated.

Thanks in advance for your help..

Kimberly



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Deleting row using vb code? hol Excel Discussion (Misc queries) 4 November 30th 07 02:43 PM
Deleting the area code on excel spread sheet phone numbers?? Ben Excel Discussion (Misc queries) 4 October 3rd 07 01:34 PM
VBA Code for Deleting a Row [email protected] Excel Worksheet Functions 3 September 6th 07 03:23 PM
Deleting Code from VBA Noemi Excel Discussion (Misc queries) 1 January 24th 06 08:55 AM
Deleting code in a file with code.. KimberlyC Excel Programming 3 March 4th 04 09:24 PM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"