Macro that runs through certain range of rows

[OceanBlue]

I have attached a Macro enabled Sheet.

I have recorder a Macro that will take the Line starts with TC1 to stay in Cell B

and line starts with

Expected result
to be pasted into cell C

As you can see that I ran the Macro successfully for B9 & C9

However, my intention was to have the Macro run through the rest of the rows.

In another way, kind like with an IF statement.

until all rows has been adjusted.

Not too sure how thought?

[pike]

hi OceanBlue
maybe a simple loop

Please Login or Register  to view this content.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

After you've just recorded a macro is the best time to edit down the resulting code to take out all the "bloat" that isn't needed, especially with formatting. Excel does a lot of "block" formatting commands, so you know all you did was set the Wrap text flag, so edit out the stuff you know you don't need.

[Oceans]

Thanks..............................

[Oceans]

Thank you..............................