Search:

MS Office Answers

Ask Question UnAnswered

Question Asked By: Abelerd Fischer on Jan 24 In MS Office Category.

Is there a simple command that can check if a worksheet exists?

Question Answered By: Mildred Bailey on Jan 24

If wb Is Nothing Then Set wb = ActiveWorkbook
On Error Resume Next
SheetExists = CBool(Not wb.Worksheets(Sh) Is Nothing)
On Error GoTo 0

Didn't find what you were looking for? Find more on Is there a simple command that can check if a worksheet exists? Or get search suggestion and latest updates.

Related Topics:

Tagged:is there simple command that can check if worksheet exists

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us