View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Joe[_9_] Joe[_9_] is offline
external usenet poster
 
Posts: 18
Default Macro for renaming worksheets

Good evening all,
I am trying to write a macro that renames the worksheets within a
workbook. My problem is that the same worksheets don't always exist in every
workbook. I am trying to create the macro to use an If statement to skip
over the worksheet if it doesn't exist without halting on an error. Thank
you in advance.

Joe