Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add rows, to point to new row
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add rows, to point to new row
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add rows, to point to new row
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add rows, to point to new row
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add rows, to point to new row
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add rows, to point to new row
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",...) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |