Creating a pivot table from different sets of data using a macro

[Éidhne in Ireland]

Hi,

I'm trying to create a pivot table from an external text
file using a macro. The data always has the same number
of colums (12), but the number of rows varies. This is a
problem - when I record the original macro the data range
for the pivot table is stored in it. When I try to run the
same macro on a data set with a larger number of rows, all
data after the final row indicated by the original data
set is ignored.

Any suggestions greatly appreciated.

Thanks in advance......