why do people use macros when PQ exists within Excel
They do very different things. I've got macros to add corporate branding on headers, format pivot tables how I like them, google search the value in the current cell, generate invoices and email companies their outstanding balances, etc
I also hate macros.. where did that hard coded value come from?
Cntrl [ functionality.
Edit to add.. why do people use macros when PQ exists within Excel?