$$Excel-Macros$$ Re: VBA to merge / unmerge identified rows when target is used

2017-03-12 Thread Maatangi M. Karthik
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.

$$Excel-Macros$$ Creating a pivot table using macros

2017-03-12 Thread Vikash Hypio
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.