View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DoooWhat DoooWhat is offline
external usenet poster
 
Posts: 37
Default If no list exists, exit sub

I need help with the syntax on a conditional statement in a macro.
The macro works perfectly if a list (filtered list) exists. However,
if no lists exist on the page, I get an error message. I want to
start my code with a condition that does the following:

If no list exists
Exit sub
Else
...........

I can take it from there. Any help would be very much appreciated.

Kevin