Variable pivot table range I've got data in columns A-Z starting in row 2 and this feeds a pivot table.

Is there any way to specify the source range without having to use a reference of $A$2:$Z$1048576

I've tried using the TrimRange dot, e.g. $A$2.*$Z$1048576, but that reverts back to a fixed range of the actual...
https://www.excelforum.com/sho....wthread.php?t=143726