referencing an Offset range

[penfold1992]

So im trying to make a function that uses this formula:
H6=I6-(SUM(C6:G6) but instead of I6 C6 and G6 and H6 a named variable (ill call Ref)
so Id like something like this...

Range(ref).Offset(0,1)-(SUM(ref.Offset(0,-5) : ref.Offset(0,-1)
The first part is easy

Please Login or Register  to view this content.

however I dont know how to figure out the next part because ref.offset(0,-5) returns the value rather then the reference as a cell

Can anyone help?

[JBeaucaire]

Hmm, so maybe something like this:

Please Login or Register  to view this content.

[penfold1992]

close... This is what I wanted:

Please Login or Register  to view this content.

thanks though, helped a lot!

[JBeaucaire]

If that takes care of your original query, please select Thread Tools from the links above and mark this thread as SOLVED. Thanks.