Hi,

Not sure if this is possible, but hope someone can help.

I'm trying to create a macro that will look at column A from row 10 to 100
for certain words. These words would be in a list, i.e. "Word One", "Word
Two", "Word Three", "Word Four", "Word five", "Word six", but also this is
not case sensitive, so it would look at the text if it was upper or lower
case. Could these words be in an array or not, I'm not very good at writing
macros so please bare with me.
Then the cell that contains this word would make the same row but column D
active, if you know what I mean.

Hope someone can help,
Thanks
Best regards,
Scott