Time Formula

[I.P]

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

[Toppers]

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
>
>

[I.P]

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