I've just started using the hyperlinks so everything is just set to go to
cell A1 now. What I want is to find the first blank cell in column J and
then position the cursor in the next row in column C. I thought I could use
the COUNTA function to identify the first blank cell, but I don't know how to
make the cell in column C active. I might just be entering the reference
incorrectly.

"Frank Kabel" wrote:

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.