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
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?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
[vba]
Worksheets(Range("A1").Value).Activate
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
Thank you a lot...It's work
Posting Permissions
Reply With Quote
