Dr. Watson - Ugggghhhhh!
Posted by Melanie Swarner on October 23, 2001 11:55 AM
I am getting a Dr. Watson error because of the following line of code:
ActiveCell = ActiveCell + LookupValue(Product, ProdList, Offset)
Here's what LookupValue does:
Function LookupValue(Product As String, ProdList As Range, Offset As Variant)
LookupValue = Application.VLookup(Product, ProdList, Offset, False)
The function works, because I'm using it all over in my code. It's just this line. If I comment it out, it's fine. I tried putting in a HoldCell variable to hold the contents of the ActiveCell and then add them together later and I still get the error. The error log means nothing to me.