how to write and record macros to customize your workbook, and how to run macros to automate and speed up repetitive tasks.

Clicking a button does nothing. All of the buttons (and other objects) in my workbooks are tied to macros. You must allow Excel to run these macros for the buttons to work. Be sure that you click ...

The macro READIT then uses the %BQUOTE function to allow a %IF condition to accept the unmatched single quotation mark: data test; store="Susan's Office Supplies"; call symput('s',store); run; %macro ...