Hi
I have recorded a macro to first delete all cells in a sheet and then create Pivot table from Union Query .
After recording , when i run it, it gives me error.
Following is the macro
Can anyone correct it, and also change its path to active workbook
Regards
Please Login or Register to view this content.
Can anyone help me on modifying this code?
Can you post a sample workbook?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks