View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eric c eric c is offline
external usenet poster
 
Posts: 1
Default How a macro auto-determine unspecified range


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

--
eric
-----------------------------------------------------------------------
eric c's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27254