View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
freddy freddy is offline
external usenet poster
 
Posts: 87
Default Explain use of function property

My goal is to check for the existence of a worksheet named "Invoice" within
an open workbook. If it exists, then print it. If not, continue with the
existing macro which prints another worksheet tab which will always exist. I
need to know if I can use a function to test whether the "Invoice" worksheet
exists by returning a true or false value, instead of just attempting to
select the worksheet and taking a risk of it not existing then writing error
handling code.