VBA Help...

[Jav_uk8]

Hi All,

VBA help

I have a total column in row 664 (this will be variant week to week)

I need the VBA to calculate L664 / K664 but like I mentioned the above, it will not be fixed to this row every week.

What I have so far is:

Range("N1").End(xlDown).End(xlDown).Offset(2, 0).Select
ActiveCell.FormulaR1C1 = "% of Collection Rate"

Range("O1").End(xlDown).End(xlDown).Offset(2, 0).Select

Hope this makes sense?

Cheers

Jav

 

[Jav_uk8]

IDEAL!!!!!

Works a absolute treat, thank you for your assistance!