Error with Code within Spreadsheet'

[mprice1988]

I tried to create a dependant validation drop down list in my spreadsheet but I have now somehow stopped my search function in the spreadsheet from working.

It keeps telling me 'No data found' when it did beofre I was playing around with it?

I have attached it, does anyone know what I have messed around with?

[NBVC]

To me it looks like you need to expand the Named Ranges, Brand, MPAN and Tariff. Right now they only include date to row 76 but you have data to row 223.

[mprice1988]

But even when I search for infor before row 76 I its not returning any matches?

[NBVC]

I tried to create a dependant validation drop down list in my spreadsheet but I have now somehow stopped my search function in the spreadsheet from working.

It keeps telling me 'No data found' when it did beofre I was playing around with it?

I have attached it, does anyone know what I have messed around with?

When exactly do you get that error and what do you do to get it?

Where are the results supposed to go and what are the results supposed to be?

[ratcat]

Just guessing here,

Cross post.

http://www.excelforum.com/showthread.php?t=645303

If so its fixed.

Need the thread starter mprice1988 to comfirm please.

[royUK]

I think your reference to vFind is wrong. I have amended the code & it seems to work

Please Login or Register  to view this content.