Range("b7")*range("b8")

or

Cells(7,2)*cells(8,2)

If the result is to go into a cell (say A1), then
Range("a1")=Range("b7")*range("b8")

HTH

"PCOR" wrote:

Using VBA what syntax do I use to Take the figure in B7 and multiply it by a
figure in b8
Thanks


--
Norton Professional 2004 says this email is clean...believe it