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