What on earth am I doing wrong here - tearing my hair out!
It doesn't seem to like mixing the long with a range, how can I fix this? Thanks in advance.Please Login or Register to view this content.
What on earth am I doing wrong here - tearing my hair out!
It doesn't seem to like mixing the long with a range, how can I fix this? Thanks in advance.Please Login or Register to view this content.
Last edited by tone640; 05-14-2012 at 06:45 AM.
it needs to be text
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks for your help, I'm getting a different error saying that the pivot table field name is not valid, and needs to use data in a list with labelled columns.
I have checked that every column from A to BQ has a heading, but still no luck.
are you sure you have no hidden columns with blank headers and that the headers are in row 1? if so, maybe you have an invalid character in the field name - can you manually create a pivot table from the data?
Yes, no hidden columns or blanks in row 1, and I can update the sourcedata for the pivot table manually.
are you sure that the code is using the correct sheet? a sample workbook would probably speed this up. ;-)
Sample workbook attached...
weird. seems to work with R1C1 format (which I prefer with pivots anyway especially with large datasets)
Please Login or Register to view this content.
Ah so simple but it's odd you can't use the other format...
Thanks for your help, it is much appreciated.
Why not just use a dynamic named range and skip the VBA?
Thanks for the suggestion - that would be a better way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks