How to add rows, to point to new row

N

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.
 
P

Paul Lautman

nastech said:
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.
Click to expand...

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.
 
N

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..
 
P

Paul Lautman

nastech said:
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?
Click to expand...

Put excel dynamic ranges into google and you'll see
 
N

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?
 
P

Paul Lautman

nastech said:
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?
Click to expand...
If you want the contents of the cell refered to by OFFSET, you don't need
the CELL("address",...)
 
Top