Loop & Find problems

I am trying to create a loop Macro that will search for the word "pediatric" in Column C of each Row, and when "pediatric" is found, enter "Peds" in Column E of that row.

I created this macro using Record and then added a Loop function, but it is not working. I am getting a Loop Do syntax error when I "step into" the macro. As I'm sure will be obvious, I am very much a beginner with macros.

Can anyone please tell me what mistakes I am making here?

Thanks very much!

Please Login or Register  to view this content.

Welcome to the Forum.

You need to take the few minutes necessary to read the Forum Rules - see the link below. Your Thread Title needs editing & you haven't used Code tags, I will add these for you now.

Welcome to Exceltip forum

Please take a couple of minutes and read the forum rules then edit your thread title by following the instructions in the rules (Rule 1) and wrap your VBA code (Rule 3)

An Announcement thread that covers the rules is at the top of each forum or you may use the link below in my signature.

Try this

Please Login or Register  to view this content.