How about a formula of

=IF(AND(A1<"",B1<"")A1*B1,"")

--

HTH

RP

"eric c" wrote in message
...

Hi,
I have some data in column a & b, but the nos of input is not
specified; in column c a formula a*b is made. Can anyone advise me how
a macro to copy the formula to the range in column C that just match all
data in column a&b?
Thank you.


--
eric c
------------------------------------------------------------------------
eric c's Profile:
http://www.excelforum.com/member.php...o&userid=15739
View this thread: http://www.excelforum.com/showthread...hreadid=272543