Make code more efficient

Hello

I was hoping somebody may be able to help make a section of code I have more efficient.

The scenario is that I have a long list of items which I want to search through, autofilter is not really an ideal solution as I want more control over where I position the combo box with the search values.

I have a basic combo box which passes a value to a specifc cell, I then use this value to determine if a row should be visible or not. The code works fine and does what it is meant to, however, it is just too slow.

Please Login or Register  to view this content.

Please Login or Register  to view this content.