Dynamic starting point

[scarlettw123]

Below is what my macro currently looks like. I use this when I download a report from SAP into Excel. After the report is download I wanted to create a macro that moved all the blank spaces on a row over to the left. My issue is that the starting point isnt always at 54. It changes every time I down load the report. How can I change this so that the macro starts running after a certain word. Specifically the word Components. The macro has already been ran and there is some personal editing I did to the sheet. Please see the attachment as well.

Please Login or Register  to view this content.

[JBeaucaire]

Perhaps something like this:

Please Login or Register  to view this content.

[scarlettw123]

It didnt work.

[JBeaucaire]

Your question was "How to replace the 54 in the existing macro with a routine that can fine the row AFTER the word 'components'?"

The tweak I offered you does exactly that. On your sheet it resolves the "Rw" variable to 58, which IS the row after the word "Components".