Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't figure this out... | Excel Discussion (Misc queries) | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
Can't figure this out!!! | Excel Worksheet Functions | |||
Can't figure out | Excel Worksheet Functions | |||
Still trying to figure it out | Excel Worksheet Functions |