Target.address

I have this written to take the text in a cell that I select and go to the sheet with that name if it's there.

Please Login or Register  to view this content.

It works fine, except when I select more than one cell.

I get Run Time Error '13': Type mismatch on

Please Login or Register  to view this content.

I am not sure what's going on, anyone have thoughts?

Try this:

Please Login or Register  to view this content.

Thanks guys!!!

I got it.