Hi All,

I am new to this forum. Hope u guys can help me wif my problem.

I developed a small tool for my company using EXCEL 2003 - VBA. It works well on some machine but not on others. For few machine, they would get the above error. I have a master sheet on the excel where user click 'Refresh ALL' button, all data on all the sheets will be updated with current data and each sheet has a button to refresh its data too. The button on each sheet works very well. But for the 'Refresh All' button, user will encounter the error. Below is the part i suspected is giving the error:

Sheet2.Range("A3").CopyFromRecordset rs



Hope u guys out there can help me. Thks in advance.