i have a workbook with over 50 sheets
I wanted a macro to find the sheet without scrolling to find it
I have found this macro (from a helpful member)
it has worked fine in the past
but now the sheets are many & it sometimes gives me error
& returns "you didnt enter a sheet number or press cancel"
when i delete a sheet it works?!
one more thing how can i increase the size of the inputbox so all the sheets appear so i can type which one i want
in this workbook when i delete any sheet
the inputbox shows till sheet 13 only (i cannt see the rest)
any help is appreciated