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

Thank you, actually I want to like this:
C1=Days360(A1,B1)
C2=Days360(A2,B1)
.....
C100=Days360(A100,B1)
When worksheet open,how?Thank you.

I have tried as this

Code:
--------------------

dim x as integer
for x=1 to 100
c&x="=days360(A&x,B1)"
next

--------------------

but variable x not change anymore, what is wrong?


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