hi, not sure if i can answer, or if what you want, but have a hyperlink for
manuevering thru a document:

=HYPERLINK("#"&CELL("address",OFFSET($A$402,IF(ROW ($A$402)<(ROW($A402)-($Z$3/4)),-1,$Z$3),1)),"B")

z3 is a cell that calculates number of rows available, minus freeze-pane
header:
($Y$3-CELL("row",$A$17))-2

y3 is number of rows..

"peyman" wrote:

hi,
I'm having a dynamic hyperlink by the following code:
Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Select
but the problem is when I drag a formula like this,=IF(C127,"YY",""),
downward.

in this case the active cell will shift to the last cell in which we have
the formula, but I want it go to the last cell with "YY".
any help?
thanx