I have small problem in Excel macro.
I am trying to do two processes based on existance of sheet.
If sheet exist i will perform process 1 and if sheet does not exist then process2.
i am using following code
but the sheet "activity" does not exist. error i got is "subscript out of range".
I want trap(skip) this error and proceed further. I need a fucntion which can give output whether sheet exist or not.
can somebody help me ?
Thanks in advance.