thanks, have been working on it alittle. Found somenting that might be good
for up or down (1 link - 1 button).
- item: (Mr. P) think I made a mistake on something in past, response
more personal nature, if you want to send blank email to nasgentech @ yahoo,
will reply. thanks
minor problem, just trying to cut # of hyperlinks using, in half (up vs. dn)
- item: would need to replace: row($A$20) with something more dynamic
(trying to get 1 button that works for up & down in a hyperlink).
This example works, but only if hyperlink is in the same line as: title
line / where working
=HYPERLINK(IF(ROW($A$100)>=ROW($A20),"#"&CELL("address",OFFSET($A$100,$Z$1,1)),"#"&CELL("address",OFFSET($A$100,-1,1))),"x")
Question: is there a way identify what "LINE" is currently in view / at
top of screen / below freeze pane, for modifying: row($a20)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX