The problem I'm having is that the cells I need to select are never in the same range. I haven't been able to find any code that can do this, so I think I might just have to take the long way around. The header is formatted one way, while the subtotals and grand total rows are formatting another way. The header always begins in A3. I was thinking of something along the lines of this:
1. Select A3 and extend selection out to the last cell in row 3 that has data in it. With that selected, I can apply my formatting code
2. Search column A for any cell that contains the word "Total", select that cell, and then extend that selection out to the last cell with data. Then I'll apply my formatting code. Next, continue down searching for the next cell in column A that contains "Total" and do the same, all the way down to the last row of data which will be the grand total.
3. Repeat step 2 for column B and C
I already have the code to format these selections, but the other parts of this project are beyond me at the moment. Any thoughts?