Hey Guys,

Thanks in advance for the help, I've been a big fan of this forum for quite a while. Ok, I created a macro that creates a pivot table, the problem that I'm having is that I can't figure out how to select the bottom row and fill it yellow, as you know with pivot tables the second column in the bottom row is a blank cell and the pivot table is dynamic so that the bottom row changes each time i run the macro. The second issue is that I can't figure out how to fill the borders for the cells inside the pivot table are a including the cells that are empty.

I look forward to your comments.....