Hi again Die_Another_Day,

You're a real champ. Your codes work perfectly. Just 1 more question: where
can I locate your FindLastRow object?

Very much appreciated & have a great weeekend.
Eric


"ecctse" wrote:

Hi,

I am trying to create a pivot tables using VBA with different number of rows
of source data. How can I supply the number of rows as a parameter to the
following method:

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:="???"

It seems it doesn't like me to supply a string variable to the SourceData,
for example, SourceData:= strRange

Any other method to get around? Thanks.