View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rbanks[_16_] rbanks[_16_] is offline
external usenet poster
 
Posts: 1
Default Macro to delete worksheets


I have a workbook that has almost 600 tabs, but only about 200 have data
that I need.

Can anyone help me write a macro that check the value of a certain
cell, say W300, and deletes each worsheet where it equals zero?

thanks


--
rbanks
------------------------------------------------------------------------
rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944
View this thread: http://www.excelforum.com/showthread...hreadid=521753