Formula generator, using variable as one of the numbers with VBA

Hi,

I am trying to idiot proof a new spreadsheet. In the sheet I use the following formula for time "=f10+(1/24*3) where the last number is the length of support. I want to make a formula generator to change this last digit. I tried:

Sub CreateFormula()

Dim x As Integer
x = Range("bp154").Value
Range("bq154").Formula = "=bp154+(1/24*x)"
Range("bq154").Select

End Sub

And it didn't work, any advice where i went wrong?

Thanks,

Craig

Hi

maybe this..

Please Login or Register  to view this content.

zeddy