Tag: VBA
Match Product Chart Colors to Excel Spreadsheet Cells – Pete’s VBA Solution
In the recent Friday Challenge: Create Pipeline Usage Chart
A user wanted to create a bar chart where the values had a specific color by...
Show or Hide Selected Chart Data Points in Excel with VBA
Okay, for the last challenge, Peter went above and beyond and also submitted a VBA solution to this problem. Great job Peter!
Here is how...
How-to Show an Apostrophe at the Beginning of a Text String in Excel
I saw that an Excel user was having a problem when creating his VBA code and you may run into this problem when you...