Code puts title in first row, want it in every row

Hey everyone,

I have a question regarding coding. I have had some help to build out this code to look for all regular services, but then I would like it to place the title of the service put in the next column.
I have it built out so it puts the "regular" service title in the first additional service row, but only the first one.
I would like it to place it in every additional service row, not just the first.
This is what I have running it so far..

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Coding Question" does not tell us about your question. I have updated it for you this time because you are a new member. --6StringJazzer

Well, this Other".Cells(1) makes no sense. A string value cannot have a cell reference attached to it.

I have no idea. You have the advantage of me/us in that you know what your data looks like and what you are trying to achieve.


Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.