Subscript out of range error
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.
|