Another way to do it would have been to use the application.goto

Application.Goto Worksheets("NPDES Ind Order").Range("B1")
or
Application.Goto Worksheets("NPDES Ind Order").Range("B1"), Scroll:=true



rink wrote:
<<snipped
Yes, you are correct. I was getting to the correct worksheet but not
the correct cell. I did as you suggested and now it takes me to the
correct sheet and cell.

Thank you very much,

Bob

--

Dave Peterson