Thread: I require a macro to complete ignoring the following error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phil phil is offline
external usenet poster
  
Posts: 201
Default I require a macro to complete ignoring the following error
Run Time Error 1004
Unable to get the LegendEntries of the properties class

This error happens in a macro because users enter invalid parameters. This
means a pivot table fetches no data. Can the error be ignored so the macro
completes and the user can go back and enter valid parameters?

TIA

phil
Reply With QuoteReply With Quote