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