Dynamic range for pivot table

hi


What line errors when you step through the code a line at a time by pressing [F8]?
I'm guessing it is the "pivotcaches.creates..." line, so I've made some modifications...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

hth
Rob

hi,


Do all of the columns in the range (from column A upto & including column S) have Headers (ie text) in row 1?


I'm sorry, I don't know what is going wrong for you...
The below works for me in Excel 2007 (I'm on a different computer):

Can anyone else suggest how the error can be fixed?

Please Login or Register  to view this content.

Rob

For some reason I can't open the dummy file ("...wrong format or corrupt..."), can anyone else open the file in Webbug's previous post & suggest how the runtime error can be fixed?


Webbug, I'm on Excel 2007 at the moment but can't open the xlsm version, would you be able to upload it as an "'97-2003 compatible .xls" file?

Thanks
Rob

This works for me in Macro2

Please Login or Register  to view this content.

Dear Andy and Rob,

This worked perfectly.

I will really appreciate if you could kindly address the following request.

http://www.excelforum.com/excel-prog...ml#post2083801

Webbug

Thanks Andy :-)

Do you have any idea if there is somewhere in the VBE or Excel options that could allow the use of "rng" to work for me (without a conversion to a string) but not for Govind?
(I had had a go at converting to a string based on viewing my recorded macro but I must have missed a ".parent" section.)

Rob

For xl2003 this version of the code will work without converting rng to a string reference.

Please Login or Register  to view this content.