[RESOLVED] [Excel 2007] Error message for no reason-VBForums
Results 1 to 3 of 3

Thread: [RESOLVED] [Excel 2007] Error message for no reason

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    9

    Resolved [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,

  2. #2
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,787

    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!

  3. #3

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    9

    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
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.