LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please explain YIELDMAT function JoeU2004 Excel Worksheet Functions 9 September 10th 09 02:04 AM
Large function - Please explain Danny Excel Worksheet Functions 5 December 18th 07 08:34 PM
Please explain function/formula Tara H Excel Worksheet Functions 6 July 24th 06 07:16 PM
can someone explain function 'ara'? feachmarsin Excel Worksheet Functions 1 April 20th 06 01:26 AM
Function behaviour, can someone explain please? Ron[_28_] Excel Programming 2 February 8th 05 03:49 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"