Thanks, I'll check it out.
Hi Mynda! So what if I add a worksheet, and its table has a column that didn't appear in any of the original tables. How do I get the query to reco...
You could follow my tutorial, Excel Waterfall Charts.
I have a tutorial on just this topic: Conditional Formatting of Excel Charts.
The cited approach is nasty. All the user wants to do is get out of the dialog, and making the Red X not work punishes the user for your own poor desi...
It's hard to know a priori which VBA commands need to be waited for. While testing code, you may find errors after certain commands, and placing DoEve...
Can you find the expert's code in the workbook they provided? Use the project explorer pane (usually top left of the VB Editor) to look for it. If ...
What I've heard is that charts linked to pivot table data now act as pivot charts on the Mac, without having the various pivot-related buttons on them...
Suppose my scores with duplicates are in B3:B19. I can get simple ranks if in C3:C19 I use the formula =RANK(B3,B$3:B$19) But duplicate scores w...