Pivot Table DataSource

[snowbored]

hola - having a nightmare with a pivottable in VBA. I cannot give it a dynamic datasource. Surely i must be coding this wrong.

please take a look at the code

it breaks on setting the range for PTRange with the error

Run Time Error '1004'

application-defined or object-defined error

Please Login or Register  to view this content.

cheers

[shasur]

Hi

Are you sure lastrow_rng and lastCol have some values like one below

Please Login or Register  to view this content.

[snowbored]

hi shasur-

yes they are variables set dynamically above

in this instance

lastcol = AY
lastRow_rng = 16899

[Andy Pope]

lastcol needs to be numeric rather than the column letters.

lastcol = 51 'AY

[snowbored]

hey andy, niceone...didnt think of that

but still getting the same message

lastcol_rng = Range("A1").End(xlToRight).Column

so lastcol_rng = 51 as you said

but still this irritating message grrr

am i setting PTRange correctly?

Please Login or Register  to view this content.

[Andy Pope]

Do you mean

Please Login or Register  to view this content.

[snowbored]

sorry my bad.

still not working - same error message

close to giving up and use messy record macro style

[Andy Pope]

Currently you problem has nothing to do with the pivot cache or table code so this is simple an assigment of a range to a range object using parameters.

Does the following error?

Please Login or Register  to view this content.

[snowbored]

that returns

A$$1:$AY$16384 (when applied to my range)

now the same error is here:

Please Login or Register  to view this content.

[Andy Pope]

Where did the Create method come from?

Try using

Please Login or Register  to view this content.

[snowbored]

it came from my retarded brain. ive been staring at this code too long

cache now added. i've got another error with

Please Login or Register  to view this content.

but i shall sort that out

thanks for the help andy