Formula in VBasic

S

SB

Hello,

I have following problem; with help of a macro I want to copy a formula in
different cells. The formula is
ActiveCell.FormulaR1C1 = "=MATCH(RC[-21],Comments!C[-21],FALSE)"
The formula starts in cell V22 and finds the Vlookup value in cell A22. When
I copy the formula down, the row number will be adjusted. But when I copy
same formula to cell W22, it refers to value B22. How can I fix the formula
in Vbasic, to look at always the same column and only adjust the row numbers?

thanks in advance for your help!

regards
SB
 
B

Bob Phillips

Is this what you want?

ActiveCell.FormulaR1C1 = "=MATCH(RC1,Comments!C1,FALSE)"
 
S

SB

Hi Bob,

yes, thanks! That was really simple, but exactly what I needed ;-)

regards
SB

Bob Phillips said:
Is this what you want?

ActiveCell.FormulaR1C1 = "=MATCH(RC1,Comments!C1,FALSE)"


--
HTH

Bob Phillips

SB said:
Hello,

I have following problem; with help of a macro I want to copy a formula in
different cells. The formula is
ActiveCell.FormulaR1C1 = "=MATCH(RC[-21],Comments!C[-21],FALSE)"
The formula starts in cell V22 and finds the Vlookup value in cell A22. When
I copy the formula down, the row number will be adjusted. But when I copy
same formula to cell W22, it refers to value B22. How can I fix the formula
in Vbasic, to look at always the same column and only adjust the row numbers?

thanks in advance for your help!

regards
SB
Click to expand...
Click to expand...
 
B

Bob Phillips

Pleasure mate.

--
HTH

Bob Phillips

SB said:
Hi Bob,

yes, thanks! That was really simple, but exactly what I needed ;-)

regards
SB

Bob Phillips said:
Is this what you want?

ActiveCell.FormulaR1C1 = "=MATCH(RC1,Comments!C1,FALSE)"


--
HTH

Bob Phillips

SB said:
Hello,

I have following problem; with help of a macro I want to copy a formula in
different cells. The formula is
ActiveCell.FormulaR1C1 = "=MATCH(RC[-21],Comments!C[-21],FALSE)"
The formula starts in cell V22 and finds the Vlookup value in cell
Click to expand...
A22.
When
I copy the formula down, the row number will be adjusted. But when I copy
same formula to cell W22, it refers to value B22. How can I fix the formula
in Vbasic, to look at always the same column and only adjust the row numbers?

thanks in advance for your help!

regards
SB
Click to expand...
Click to expand...
Click to expand...
 
Top