hi,
I have a dynamic hyperlink by the following code:

Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Select

it works well but the problem is like when I drag a formula like
this,=IF(C127,"YY"," ") in column A. it's like for example when the cell C127
is not empty the the cell A127 will be YY and so on.
in this case the active cell jumps to the last cell in which we have
the formula, but I want it go to the last cell with "YY".
any help?
thanx