I am trying to write a script so that when a user clicks on a radio button the formula in a cell changes.

my code is
Range("d10").Select
ActiveCell.FormulaR1C1 = "=(B10/C10)+(30/60)"

but when I click on the button the formula entered is
=('B10'/$K:$K)+(45/60)

why and how do i fix it??

Thanks

Hi

only a small change needs to be made here instead of using
ActiveCell.FormulaR1C1 = etc.
use
ActiveCell.Formula = etc.
the C reference in your formula is getting interpreted as a column i.e. K

I hope this sorts your problem for you

David