Audax
03-17-2008, 01:43 PM
Please somebody help me
I've renamed 100 worksheets with numbers 1 thru 100, (worksheet 1= 1..worksheet 2=2..etc). I have a macro that generate a number from 1 to 100 and put the result in Cell A1, says 58 for example..After run the macro I want the worksheet which is in cell 1 ...58 in this example Active..It's possible?
Thank you very much
I've renamed 100 worksheets with numbers 1 thru 100, (worksheet 1= 1..worksheet 2=2..etc). I have a macro that generate a number from 1 to 100 and put the result in Cell A1, says 58 for example..After run the macro I want the worksheet which is in cell 1 ...58 in this example Active..It's possible?
Thank you very much