Hi

I am trying to run the macro but I get a “runtime error no 9: the index is outside of interval”. I’m a newb when it comes to MS Excel and programming. The problem is in the line

MyKeys = Sheets("Keywords").Range("A2:A" & Sheets("Keywords").Cells(Rows.Count, 1).End(xlUp).Row)

of the macro.

How should I change it to conform with my spreadsheet?

Thanks for your help!

/Johan