Re: How to add rows, to point to new row

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.


.

Relevant Pages

  • RE: Wild Card Vlookups
    ... 'Cell Formula using the OFFSET worksheet formula with multiple criteria to ... 'Returns a reference to a range that is a specified number of rows and columns ...
    (microsoft.public.excel.misc)
  • Re: Nesting Address function in Offset without Quotes???
    ... The INDIRECT function will convert your text string "A1" into a cell ... is a cell reference. ... Address does the trick except that the offset function ... quotes). ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Using an offset formula for the reference in a relative refere
    ... Sheet1!A1:C4 and A1 is linked to a cell in Sheet1!A1:C4 ... I will need to figure out how to extract the variable cell reference data ... Sheet 2 to populate the row and column info in the INDEX/MATCH ... I can embed an OFFSET formula in the ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Using an offset formula for the reference in a relative refere
    ... I will need to figure out how to extract the variable cell reference data ... from cell A1, Sheet 2 to populate the row and column info in the INDEX/MATCH ... since the number of rows for the offset will be ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Create cell formula from a relative position
    ... reference - just as if you had typed it). ... You can try to use your code to figure out the proper cell addresses to ... > but it only calculates the absolute position of C1*H1 ... >> And, in general, this is the way it works: Offset gives a range the same ...
    (microsoft.public.excel.programming)