Divide by Cell To The Left

[Vampy99]

Hi,

I need a formula that does a simple division, the column will stay the same but the row will change dependant on what the outputs of the VB are.

Please see the code below;

Range(cellrefe & total).Formula = "=""C""&Row()/""B""&Row()"

I need;

=Candthecurrentrow/Bandthecurrentrow

I know this is wrong, but I think you may be able to see what I am trying to do.

Does anyone have any ideas?

Thanks,

Luke

 

[VoG]

Perhaps like this

With ActiveCell
    .Formula = "=C" & .Row & "/B" & .Row
End With

 

[Vampy99]

Perhaps like this

With ActiveCell
    .Formula = "=C" & .Row & "/B" & .Row
End With

Thanks VoG, that gives me exactly what I need!

Thank you,

Luke