| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HYPERLINK BY VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Threaded Mode
