Captain Smith
Active Member
- Joined
- Feb 28, 2003
- Messages
- 324
In VBA how do I do the following two things. I need syntax for the if sheets statements. Thanks.
sub help()
n = activecell
if sheets does not exist in this workbook then...
rest of code
end if
ALSO
if worksheets exists in this workbook then...
rest of code
end if
end sub
sub help()
n = activecell
if sheets does not exist in this workbook then...
rest of code
end if
ALSO
if worksheets exists in this workbook then...
rest of code
end if
end sub