R1C1 formula 1004 error

[Mpotten]

HI Brains trust

I have an issue in that when trying to insert a formula into my table i get a 1004 error and bumped in to debug mode.

the following code is from the macro I am working on. code in green is working but code in red does not work.



LastRow = Cells(Rows.Count, "B").End(xlUp).Row
Range("M2:M" & LastRow).FormulaR1C1 = "=sum(RC[1]/RC[-1])"


Columns("M:N").NumberFormat = "_-[$$-C09]* #,##0.00_-;-[$$-C09]* #,##0.00_-;_-[$$-C09]* ""-""??_-;_-@_-"


LastRow = Cells(Rows.Count, "B").End(xlUp).Row
Range("H2:H" & LastRow).FormulaR1C1 = "=trim(right(RC[-1],3)"

 

[6StringJazzer]

Your formula is missing a right parenthesis.

Range("H2:H" & LastRow).FormulaR1C1 = "=trim(right(RC[-1],3)[COLOR=#FF0000])[/COLOR]

Also I recommend using CODE tags.

 

[Mpotten]

typical I was staring at that for ages and could not work it out.

appreciate your help thanks

 

[6StringJazzer]

My answer was missing a close quote

Range("H2:H" & LastRow).FormulaR1C1 = "=trim(right(RC[-1],3)[COLOR=#FF0000])"[/COLOR]