Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Hyperlink
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Hyperlink
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic hyperlink | Excel Discussion (Misc queries) | |||
Dynamic Hyperlink | Excel Discussion (Misc queries) | |||
dynamic hyperlink | Excel Discussion (Misc queries) | |||
Dynamic hyperlink | Excel Discussion (Misc queries) | |||
Dynamic Hyperlink | Excel Worksheet Functions |