View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Macro Help[_2_] Macro Help[_2_] is offline
external usenet poster
 
Posts: 1
Default Macro Help - check existing tabs

I have a macro that takes data from an existing tab,
creates a new tab called "Final", and does some
formatting stuff with it. An improvement I want to make
is to have the macro check the workbook at the beginning
to see if it already has an existing "Final" tab, and if
so, prompt the user whether to delete the existing tab or
quit the macro. How do I make this work?

Thank you