-
May 8th, 2012, 08:53 AM
#1
Thread Starter
New Member
[RESOLVED] [Excel 2007] Error message for no reason
Hi,
I am getting an error message to this line: Dim PT As PivotTable
and the error message is:
Compile error:
A module is not a valid type.
The problem I am facing is that I have run this macro hundreds of times without getting this error message and since yesterday I have been stuck at this point.
Any input why all of a sudden I have started getting this error message?
Thanks,
-
May 9th, 2012, 06:27 AM
#2
Re: [Excel 2007] Error message for no reason
Reading the error message I would bet you have created a module named "PivotTable"!
You're welcome to rate this post!
If your problem is solved, please use the Mark thread as resolved button
Wait, I'm too old to hurry!
-
May 9th, 2012, 12:34 PM
#3
Thread Starter
New Member
Re: [Excel 2007] Error message for no reason
Thanks, Opus
Yes, that was the problem. I copied this part of my macro to another module and like you identified the error - named it "Pivot Table"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|