total no of worksheets in the workbook
Hi
i am trying to find out the total no of worksheets in the
workbook...i have in total 4 worksheets... but somehow its
giving me incorrect value of 9...the total count instaead
of 4 is comign to be 9........
what could be the reason..
here is how i am getting it:
cntB = Workbooks(uuWkBkName).Worksheets.Count
cntB = ActiveWorkbook.Worksheets.Count
i have used this before and was never a problem..only
today its giving me this absurd error!
thanks in advance
|