Time Formula
 

I Wish to use a macro to insert ActiveCell.FormulaR1C1 =
"=TIME(6,30,0)" in a cell. With the 6 and the 30 to be variables from
a input box.
Ian

Time Formula
 

Try:

v1 = 6
v2 = 30
Range("a1") = "=time(" & v1 & "," & v2 & ",0)"

"I.P" wrote:

I Wish to use a macro to insert ActiveCell.FormulaR1C1 =
"=TIME(6,30,0)" in a cell. With the 6 and the 30 to be variables from
a input box.
Ian

Time Formula
 

Thanks worked fine, I had read the answer somewhere several months ago
when I did not need it.
Ian