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

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

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

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