View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
what HYPERLINK formula are you currently using?

--
Regards
Frank Kabel
Frankfurt, Germany

"sslabbe" schrieb im Newsbeitrag
...
I have a workbook with approx 60 worksheets in it. I have set up

hyperlinks
on the 1st sheet to take me directly to the worksheet I want to see.

Is
there any way of using a function in the Hyperlink cell reference, so

the
link will automatically position me at the right cell on the target

sheet? I
thought I could use the COUNTA function to determine the first

non-blank
cell, but the hyperlink doesn't seem to like it.