Sub changeChartTitles() Dim c As Chart ws_count = ThisWorkbook.Worksheets.Count For i = 1 To ws_count Set ws = ThisWorkbook.worksheets(i) For j = 1 to ws.ChartObjects(j).Chart Set c= ws.ChartObjects(j).Chart c.ChartTitle.Text=...
There is probably a better way to do this..if you know of one please tell me. This way looks pretty clunky to me: %GLOBAL BP_DESC_VAR BP; /* MAKE LIST...
Here’s some macro code to put a list of values from a SAS table into a bunch of variables: %LET CURRENT_TABLE_DATE = ‘APR2009’; %GLOBAL CURRENT_TABLE_DATE; %MACRO RUN_DATES; PROC SQL;...
I’ve seen a lot of ugly ways to count the number of words in a comma separated list, most of them involve an overly complicated macro. There is an...