VBA Code: Help to Use a Formula which needs to be pasted in a cell

hi,

in A1 i have date and i would need value of B1 to be Weeknumber of A1 and i use a variable to refer to the cell ( i think there is a problem with the Syntax)

Please Login or Register  to view this content.

both gives me error ( also what is the primary difference between using ".formula" and ".value")

Thanks.

You can insert formula:
Range("B1").Formula = "=WEEKNUM(A" & i & ")"

or result of formula:
Range("B1").Value = Evaluate("WEEKNUM(a" & i & ")")