To be more specific: I want to have the position of my last column and row in a certain pivot table. When there are more columns than rows...than I need a xlLandscape pagesetup, else I need a slPortrait pagesetup.
I can do this:
Select the range of the generated pivot...
then I can do this:
I determine the number of columns....(and rows, but dont need those)
At this moment I know this: Number of columns = 14. and rows are 12
Good!
But then my code fails. I'm not able to do:
Can somebody help me out? pls?
Bookmarks