VB search

This is a discussion on VB search within the Excel Questions forums, part of the Question Forums category; Hi Guys,
I have created a form in VB and have borrowed some code for a search function from another ...

Re: VB search

I've honestly not looked through the code in detail, but might be useful to understand what problems are you facing? Is it running but coming back with no answers? Is it returning the wrong answer? or is it throwing an exception somewhere in the code and if so, where?

Re: VB search

Well for a start c is not explicitly declared, would recommend you add Option Explicit to the top of your code to prevent this. Then you'll need to Dim c as Range. But to be fair that's probably not causing this error.

I think it's the fact that c is a Cell in Column A, but the offset command in the line you've highlighted asks it to look in the column to the left (which of course doesn't exist).