![]() |
How do I figure out what I need to do....
I had a system chrash and when I restored and then ran my worksheet, I get
errors when running the userform. Here is the line that traps the error: If Time < ActiveCell.Offset(0, 74) And Time < ActiveCell.Offset(0, 75) Then It appears that "Time" is not valid, but I am not sure what library was linked that had this. This HAD worked on the previous system. I tried to relink all that I had before... For furture reference, is there a way to create a "check list" or an install that will allow me to ensure that all refeences are included? Help!!! TIA |
How do I figure out what I need to do....
From VBA, Go to Tools | References.
Check to make sure nothing says "MISSING: " You can also try to export the form, then read the content in Notepad to give you a clue about what it was using. "Phillips @recycledreefs.com" <phil<nospam wrote in message news:CC6Gb.641785$Fm2.573208@attbi_s04... I had a system chrash and when I restored and then ran my worksheet, I get errors when running the userform. Here is the line that traps the error: If Time < ActiveCell.Offset(0, 74) And Time < ActiveCell.Offset(0, 75) Then It appears that "Time" is not valid, but I am not sure what library was linked that had this. This HAD worked on the previous system. I tried to relink all that I had before... For furture reference, is there a way to create a "check list" or an install that will allow me to ensure that all refeences are included? Help!!! TIA |
All times are GMT +1. The time now is 07:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com