i am trying the code below, but it is missing something??
SheetExist = 1
Set ws = Sheets(var1& var2) ( this is whats not picking up )
If ws Is Nothing Then SheetExist = 0
Sheets(var1 & var2).Select ' juiste tabblad selecteren
i am trying the code below, but it is missing something??
SheetExist = 1
Set ws = Sheets(var1& var2) ( this is whats not picking up )
If ws Is Nothing Then SheetExist = 0
Sheets(var1 & var2).Select ' juiste tabblad selecteren
hi,
try below function for check if sheet exists
for test it:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by MaczaQ; 02-07-2013 at 07:09 AM.
Best Regards
MaczaQ
---------------------------------------------------------------------------------------------------------------------------
If you are satisfied with the solution(s) provided, please mark your thread as Solved
If you are pleased with my answer consider to rate it. To thank someone who has helped you, click on the star icon below their name.
- This way you will add him some reputation points ... thanks in advance.
Try
Please Login or Register to view this content.
If you like my contribution click the star icon!
Or
Please Login or Register to view this content.
Last edited by :) Sixthsense :); 02-07-2013 at 07:24 AM.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks