The worksheets are in the same workbook? And H569 has the name of that
worksheet?

=HYPERLINK("#'"&H569&"'!a1")



Hundikoer wrote:

Now one more question

I have used hyperlinks, to open folders, that use dynamic (indirect
names)
like: =HYPERLINK("\\Smm\IntShared\Es\Data\"&H569&"";"Fol der") and like
in initial question I had in the topic.

But how can I open a worksheet in same workbook (do not want to use the
name of file) when worksheet name is located for excample in cell H569?

Regards
Hundikoer

--
Hundikoer
------------------------------------------------------------------------
Hundikoer's Profile: http://www.excelforum.com/member.php...o&userid=28301
View this thread: http://www.excelforum.com/showthread...hreadid=478715

--

Dave Peterson