Applying Macro to more than 30 columns with collapsing rows fitting criteria

[Guessfox]

The code below is what I was using to repeat across the WorkSheet, but found I can only apply to 30 Columns, when I need 100 or more. How can I get the whole same macros to apply to all columns the same way?
Column A and B have text descriptors in them.

Please Login or Register  to view this content.

[Mumps1]

It's hard to work with a picture. Attach a copy of your file and include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.

[Guessfox]

Mumps, Thank you! File uploaded. The process of the cells cells would be the same across the columns. I would like to get past 30 columns limit.

I tried to figure it out, but its not working for me in my attempted to achieve he desired outcome.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[Mumps1]

Try:

Please Login or Register  to view this content.

[Guessfox]

Mumps1,

When I change to another column the selection of "Yes" does not auto-expand the expected rows and changing columns without data does not auto-collapse rows.