ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   dynamic hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/150781-dynamic-hyperlink.html)

hamed

dynamic hyperlink
 
hi,
how can I have a dynamic hyperlink.I need the cell reference that goes to
the last blank cell of column A.
thanx in advance

Eddie O

dynamic hyperlink
 
could you clarify what you mean by "last blank cell?" Typically the last
blank cell would be in row 65536

"hamed" wrote:

hi,
how can I have a dynamic hyperlink.I need the cell reference that goes to
the last blank cell of column A.
thanx in advance


Eddie O

dynamic hyperlink
 
could you clarify what you mean by "last blank cell?" Typically the last
blank cell would be in row 65536.

"hamed" wrote:

hi,
how can I have a dynamic hyperlink.I need the cell reference that goes to
the last blank cell of column A.
thanx in advance


hamed

dynamic hyperlink
 
sorry I didn't convey the point correctly.the "last blank cell" means for
example I've filled out from A1 to A157 some figures,so the last blank cell
in the column A in the specific worksheet is A158.now I need the Hyperlink's
cell reference goes to the A158 automatically.and when I go further in the
column A down the Hyperlink cell reference goes down consequently.
thank you Eddie

"Eddie O" wrote:

could you clarify what you mean by "last blank cell?" Typically the last
blank cell would be in row 65536.

"hamed" wrote:

hi,
how can I have a dynamic hyperlink.I need the cell reference that goes to
the last blank cell of column A.
thanx in advance



All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com