Target cell by "offset" of named intersection?

  • Thread starter Thread starter pQp
  • Start date Start date
P

pQp

How do I refer to a cell by using an offset reference to another?
My current targets are referred to by intersection off named columns and
rows -
eg: =monthtotal_JUL stock_bought gives me intersection of row
"monthtotal" and column "stock_bought", but now I want another reference to
cells above the "monthtotal" row (still in the stock_bought column) without
having to name the rows separately.
I played with the R1C1 convention ( R[-5] etc) but I'm not sure it's
compatible with the intersecting name reference, or if it is, just where to
put the offset within the reference.
Can someone help me with this.
Thanks peeps.
 
Are we in VBA or worksheet formulae?

If it's WF, then use
=OFFSET(monthtotal_JUL stock_bought,rows,cols,height,width)

if its VBA
Range("monthtotal_JUL stock_bought").OFFSET(Rows,columns)
 
Back
Top