Results 1 to 20 of 24

Thread: Solved: Excel Crashing Problems HELP

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-28-2011, 02:05 PM #20
    BigJC
    BigJC is offline
    VBAX Regular
    Joined
    Jul 2011
    Posts
    17
    Location
    Quote Originally Posted by frank_m

    On my machine the following solved it. (hope it will for you) fingers crossed
    (1) I copied all the controls to the clipboard.
    (2) added a Frame to cover most of the form.
    (3) pasted the controls onto the Frame.
    (4) Reposition the controls.
    WOW! that totally worked.. Thank you

    But i get the annoying Run Time Eror 13 'Type Mismatch' now on that line. **FIXED**

    I removed the declare as page option on the newPage variable to make it an unspecified type and it works fine now.

    Why the hell would adding the frame like that stop this.. Better yet what the hell was casusing this?
    Last edited by BigJC; 09-28-2011 at 02:49 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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