How to add rows, to point to new row

[nastech]

Must be some way to point to a new row, from something like:

=CELL("row",A500) to be able to reference in the same formula, add plus
or minus lines. open to any function that would do that..

cell? row? line.. offset? do not know how to put together. thanks.

[Paul Lautman]

nastech wrote:
> Must be some way to point to a new row, from something like:
>
> =CELL("row",A500) to be able to reference in the same formula,
> add plus or minus lines. open to any function that would do that..
>
> cell? row? line.. offset? do not know how to put together. thanks.

You could use a dynamic range, or you could use OFFSET. You need to give us
more information about what it is you are doing.

[nastech]

Thankyou.. helps some... I just got to work, sorry to say every time give
more info, told cannot do it , have already / just got to work, I think,
with offset..

what is / will dynamic range do?

anyways, it is for an in document hyperlink, cut pasting lines above a title
line, was forever moving hyperlink out of position (swear every 5 minutes,
fixing cell references on 6-12 links was killing me.. ) got 1st half
recently from someone
just figured out rest:
(where z1 is the number of lines down from title line, want it to go)

=HYPERLINK("#"&CELL("address",OFFSET(A505,$Z$1,1)),"P2") for downwards
=HYPERLINK("#"&CELL("address",OFFSET(A505,-1,1)),"P2") for up

not sure what the following is doing (or if all necessary)
=HYPERLINK("#"&CELL("address",

thanks..
"Paul Lautman" wrote:

> nastech wrote:
> > Must be some way to point to a new row, from something like:
> >
> > =CELL("row",A500) to be able to reference in the same formula,
> > add plus or minus lines. open to any function that would do that..
> >
> > cell? row? line.. offset? do not know how to put together. thanks.
>
> You could use a dynamic range, or you could use OFFSET. You need to give us
> more information about what it is you are doing.
>
>
>

[Paul Lautman]

nastech wrote:
> Thankyou.. helps some... I just got to work, sorry to say every time
> give more info, told cannot do it , have already / just got to
> work, I think, with offset..
>
> what is / will dynamic range do?

Put excel dynamic ranges into google and you'll see

[nastech]

thanks, will check it out.. looks like will need to do some experimenting.
wondering about my hyperlink formula. Do you think it is complete as is /
no extraneous parts, as it is used?

"Paul Lautman" wrote:

> nastech wrote:
> > Thankyou.. helps some... I just got to work, sorry to say every time
> > give more info, told cannot do it , have already / just got to
> > work, I think, with offset..
> >
> > what is / will dynamic range do?
>
> Put excel dynamic ranges into google and you'll see
>
>
>

[Paul Lautman]

nastech wrote:
> thanks, will check it out.. looks like will need to do some
> experimenting. wondering about my hyperlink formula. Do you think it
> is complete as is / no extraneous parts, as it is used?
If you want the contents of the cell refered to by OFFSET, you don't need
the CELL("address",...)