Actually,correl function could be run properly in my excel sheet
mode,but that script couldn't,could you please help to have a look?

The excel file including that script is in attachment,each time I
opened it,press Ctrl+Shift+S,it runs favoringly on the former half,but
a run time error '1004' comes then.


--
yoyo2000
------------------------------------------------------------------------
yoyo2000's Profile: http://www.excelforum.com/member.php...o&userid=15489
View this thread: http://www.excelforum.com/showthread...hreadid=471308