VBA formulas without $

[aeewing]

Hey all,

I need to have variable formulas created without the $ so I can copy and paste the cells.

I am not sure how to do this with a vba determined range. Thanks!

    Set hhours1 = Worksheets("Pricing").Range(Worksheets("Pricing").Range("E14").End(xlToRight).Offset(rows1, -1), Worksheets("Pricing").Range("E14").End(xlToRight).Offset(1, -1)).Offset(0, -s)
    Worksheets("Pricing").Range("E14").End(xlToRight).Offset(rows1 + 1, -s - 1).Select
    ActiveCell.Formula = "=SUM(" & hhours1.Address & ")"