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
Bookmarks