Help with a runtime error on a filtering macro.

[taylorsm]

With this sites help I built a workbook that takes a long string of characters and breaks it down into subparts and then filters that throughout the workbook. I don't use the workbook, it was created to assist another and now we are receiving a runtime error. I currently don't have that workbook to provide but I was given a couple screenshots of the issue. I had them start all over in the original template and the same error occured, so I think it is something with the data file that we import in, but I am just looking for advice on where to begin to look.

[xlnitwit]

Hi,

I would suggest you begin by changing that line of code- and the following one- to use the Value2 property

Please Login or Register  to view this content.

[taylorsm]

Thanks. Can I ask why?

[xlnitwit]

Simply because the only reason that comes to mind for receiving an overflow error on that line of code is an attempt to return a large number value from a cell formatted with a date format. Using .Value2 will return the number as a Double rather than attempting to convert it to a date.

[taylorsm]

Awesome thanks! I will change that, and that was exactly the problem. one of the tabs had a number column formatted as a date. Guess I am going to have to lock the workbook down. Can't trust anyone....