I created a vbscript to transfer data from an excel spreadsheet to MS Access. I used DAO and the Range function in Excel (Range("SUM!A1").value) to get the value to put into Access.

I did a lot of programming. Then I found out the user of this spreadsheet actually goes in and adds and deletes rows before submitting to Access. I found this out the hard way when the script bombed, and I discovered the Range is "WAS" pointing to was now an empty cell.

Can I create a name for a cell, like a reference, where I can refer to the reference in programming and then if that cell shifts up or down (due to row deletions/additions) the code would still find what it is looking for?

Any ideas? If this is possible, some coding help would be great. First, how do you create the reference name. Second, how do you refer to it in code? (Instead of using the Range function to identify the location of the value)

Please help! Let me know if this doesn't make sense or if you have a better idea. Thank you!

mike_haddon@hotmail.com