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

Is this what you want?

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


--
HTH

Bob Phillips

"SB" wrote in message
...
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

Hi Bob,

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

regards
SB

"Bob Phillips" wrote:

Is this what you want?

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


--
HTH

Bob Phillips

"SB" wrote in message
...
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

Pleasure mate.

--
HTH

Bob Phillips

"SB" wrote in message
...
Hi Bob,

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

regards
SB

"Bob Phillips" wrote:

Is this what you want?

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


--
HTH

Bob Phillips

"SB" wrote in message
...
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