Highlight Subtotaled Random Cell

[Josh T.]

When trying to use the macro below for subtotaled columns I will select a range of subtotals, use the Select Visible Cells button, start the macro and it will highlight cells. However, the macro ignores the visible cells and looks at the entire range to randomly highlight. How can the macro only look at the visible subtotaled cells? I believe it has to do with Selection.SpecialCells(xlCellTypeVisible).Select, just not sure where in the macro to define visible cells.

I have just started with macros and learning as I go. From what I can tell it seems like the possibilities are endless with a macro.

Please Login or Register  to view this content.

Thanks!

Moderators note: code tags added for you - this time

[FDibbins]

Hi and welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

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

[Josh T.]

Appreciate the help. I'll make sure to do that in the future.

Thanks FDibbins!