Nice solutions, but it will break if the sheet name in A2 doesn't exist

--
http://blog.jausovec.net


"R.VENKATARAMAN" je napisal:

try something like this code(the name of the sheet is in A2 of sheet1)

Worksheets(Worksheets("sheet1").Range("a2").Value) .Activate

-----------------------------------
Greg B wrote in message
...
I want to have a macro that will look for the corresponding sheet to the
reference in cell "a2"

Is this possible and how is it possible

Thanks

Greg