Hi,
I am in real need of some urgent assistance. I have written a pretty simple vb code to do a cut & paste from different workbooks to produce a final workbook based on certain values inputed by the user.
This basically opens a raw data spreadsheet and manipulates the data then creates a new spreadsheet and pastes the relevant data to it.
The issue I am having is that these macros work fine on my work computer, I have even tried it on my PC at home and no problems there, but when my work colleague tries to run the code they get a subscript out of range error at various lines. I have stepped through the errors but can't see why they work on my PC but not hers??
This is really frustrating as I can't continue to work on this project until this is solve as this program I am writting is to make her life a little easier.
Can someone PLEASE HELP and give me some reasons as to why this might be happening?
I really, really appreciate any advice totally!
I am in real need of some urgent assistance. I have written a pretty simple vb code to do a cut & paste from different workbooks to produce a final workbook based on certain values inputed by the user.
This basically opens a raw data spreadsheet and manipulates the data then creates a new spreadsheet and pastes the relevant data to it.
The issue I am having is that these macros work fine on my work computer, I have even tried it on my PC at home and no problems there, but when my work colleague tries to run the code they get a subscript out of range error at various lines. I have stepped through the errors but can't see why they work on my PC but not hers??
This is really frustrating as I can't continue to work on this project until this is solve as this program I am writting is to make her life a little easier.
Can someone PLEASE HELP and give me some reasons as to why this might be happening?
I really, really appreciate any advice totally!