var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Combing Relative and Direct Referencing
Is it possible to combine both relative and direct referencing in a formula ?
for example, i am trying to do:
ActiveCell.FormulaR1C1 = _
the first value (RC[-1]) is relative, but the second ($H$1:$K$10) is not.
This is giving me an error
How else can i do this ?
No, once you go to R1C1 notation, then the whole thing has to be the same R1C1 format.
Originally Posted by ontheDB
you could reference the cells directly i.e.
This should do the job you want