Search for text in multiple columns with same heading - excel Macro

Hi Team,

I am very new to excel macros. I tried to write a macro for one of our requirements.

The macro renames the department based on the list of managers corresponding to that department.
It should search for a manager name in the columns H to Q and accordingly rename the department. But it is searching only column H. Please help me out. The macro text for your reference.

Please Login or Register  to view this content.

The format of excel sheet is as follows. (headings)

Number Short description Opened by Change Owner Department This Change Request is Unauthorized Reason Manager Manager Manager Manager Manager Manager Manager Manager Manager Manager