PDA

View Full Version : GOTO A different Worksheet named in cell A1



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

Aussiebear
03-17-2008, 01:52 PM
Hi Audax, A quick couple of questions if you don't mind. How will you remember what the sheets are for, if its just a number? Do you have an index somewhere?

Bob Phillips
03-17-2008, 01:58 PM
Worksheets(Range("A1").Value).Activate

Audax
03-17-2008, 01:59 PM
Thank for your interest in help me Aussiebear

Not really..I have 50 questions with 50 answers, the first 50 worksheets are the questions...1 in each worksheet..the other 50 worksheet are the answers...then when I run the macro..send me to the worksheet originated randomized.

I hope you understood..if not let me know please

Audax
03-17-2008, 02:01 PM
Thank you a lot...It's work