setting row in macro

  • Thread starter Thread starter pabs
  • Start date Start date
P

pabs

here's what my problem is...

when I use this function in my macro I would like to modify the value
that is set to -R[-10]


"=INDEX([Master.xls]defenition!R6C1:R80C5,
MATCH([Master.xls]Master!R[-10]C[28],[Master.xls]defenition!R6C1:R80C1,),
MATCH(R12C4,[Master.xls]defenition!R6C1:R6C5,))"


I need to make it dynamic.... I change the range everytime it goes in
my FOR loop. I tried doing this R[-(10 + counter)] but it didn't like
that very much :)
what is the syntax that I need to use in order to be able to add on
every pass of the for loop???



thanks

PAbs
 
Hi pabs, if you would like to a variable in the formula written in VBA
the variable part shoud be divided by a double quote and ampersand a
follows.


Code
 
Back
Top