if you mean you want c1:c100 equal to a1:a100

Range("c1:c100").Value = Range("a1:a100").Value

--


Gary


"lwong" wrote in message
...

thank you.
one more question, in the worksheet, A1 to A100 have different values,
how to program if I want to set A1=c1 up to A100=C100?what is the code?


--
lwong
------------------------------------------------------------------------
lwong's Profile:
http://www.excelforum.com/member.php...o&userid=33707
View this thread: http://www.excelforum.com/showthread...hreadid=534880