Macro to search and highlight a cell prior to the searched cell

[gjccks]

I'm new to the macro world of excel. I program industrial machine code. I want to search my code for a word, such as containing "CYCLE". When found, I want to highlight the prior cell. Thanks.

[J4kub]

Hi, try this:

Please Login or Register  to view this content.

[davesexcel]

Try this

Please Login or Register  to view this content.

[gjccks]

Thanks, That succeeded in highlighting the word searched, but not the cell prior to the word searched.

[davesexcel]

Who are you responding to?

[gjccks]

I get this solution to work, but it doesn't highlight the cell prior to the search result like I was wanting

[gjccks]

J4cub This worked but doesn't highlight the prior cell.

[gjccks]

Davesexcel. I get an error at line one.

[AB33]

I hope J4club is not offended if I butt in
By prior if you mean on the top of the searched item
Change this line of the code

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

By prior if you mean to the left of searched item

Please Login or Register  to view this content.

[gjccks]

AB33, That worked. Thanks. One other question. What do I need to change to make it search for lines that contains the word selected. Not an exact match.

[AB33]

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.