Hi all,
I have written a macro to create pivot tables in a new tab of an Excel 2013 file. The columns (A:AE) will remain static, but the number of rows will vary. For the data source, I would prefer to use a specified range based upon a dimensioned variable named EndRow, something along the...