Debug/Improve/Error Trapping for Excel VBA

I have a large spreadheet with several small and simple VBA subs that needs error trapping and decoding (I am an amatuer VBA programmer). THe main problem is a worksheet_change sub and a saveScenarios sub does not seem to work in Excel 97 or 2000 and I do not have access to earlier versions of Excel. I need someone who does to test and fix the subs for me. Also, this spreadsheet will be used by a large number of novice users on a variety of machines, so I need someone who is more familiar with VBA to anticipate and trap common potential errors and provide message boxes with appropriate notices. sample code ------------------------------ Sub InputTechnology() 'defines sheet where input data is stored Set DataSht = Range("TechnologyOffset").Worksheet 'column where input data for selected scenario is stored ColOffset = [login to view URL](Range("PlantType"), Range("TechnologyOffset").EntireRow, 0) 'first cell where cell names for each input is stored Set CellNames = Range("TechnologyCellNames") 'startrow is the row for the input data StartRow = [login to view URL] 'end row for the input data, spaces allowed EndRow = [login to view URL]([login to view URL], [login to view URL]).End(xlUp).Row Call InputData End Sub ------------------------- Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Select Case Target Case Range("PlantType") Call InputTechnology Case Range("OwnerType") Call InputOwner Case Range("GeneralAssumptionScenario") Call InputGeneral End Select On Error GoTo 0 End Sub ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, (depending on the nature of the deliverables): 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). 5) well documented VBA code that can be easily understood and modified as necessary ## Platform Excel VBA, for Excel 2003, XP, 2002, 2000, 97