Creating a Pivot for Excel 2003 with more than 255 characters in a cell

[benishiryo]

hi guys. i edited this code i found provided by Andy Pope. the whole code is not going to work because i haven't changed it. but what i'm stuck with is this part where i realised the code is not working when the number of characters in a cell exceeds 255. this is supposed to be for an xls file.

so i only need help for it to work past this particular last line of code:

Please Login or Register  to view this content.

and if you change the part in red to A1:L10, it works. as i have mentioned, it could be because of the text exceeding 255 characters. that's my guess.

[:) Sixthsense :)]

Replace this line

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

Tested in 2007, please check and confirm