Run time error 1004 - Method 'Range' of 'Object'_Global' failed

Hi I am trying to build a macro which will format the columns of a spreadsheet - basically it inserts some columns, writes formulas and highlights them. Here is a code I have got so far...

When I try to run this I get a run time error 1004 - Method 'Range' of 'Object'_Global' failed. The part of the code
Range("N2:N").FormulaR1C1 = "=(RC[-7]/RC[-2])"

is highlighted in the debugger.

Can anyone tell me why this is happening, also it would be great if you could suggest better ways of writing this code - as I am new to vba programming and most of my macros are built using the recorder and then 'working' on them.

Thanks.

Please Login or Register  to view this content.

Ok, I will need it to do it for variable number of rows since the number of rows will difffer with the data - do I need to define a lastrow variable? if so, how can I do that?

I did this...

Please Login or Register  to view this content.

....it gives me the same error again...

I did not and I do not know how to...

I am trying to get it to write that formula in all cells from N2 to the last row of the data.

It worked. Thanks - Is there anything else you would suggest to clean up the code?