I hv posted this on multiple sites, and was informed that cross posting is
to be avoided.
Like many novices, I wasn't aware of this as this is my second post.
I would like to rectify that situation. My original post can be found in
the below link. Please reply to the same there.
http://chandoo.
Hi my name is Vikash,
I am struggling with an error I keep getting while trying to create a
dynamic pivot table using a macro to automate the process. I use my data
and format the data to a table so that it is dynamic, then I record the
macro creating the pivot table but get a debug error 424.