Results 1 to 18 of 18

Thread: Solved: An error with setting a wb. Why?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #14
    VBAX Expert
    Joined
    Aug 2007
    Location
    Windermere, FL, a 'burb in the greater Orlando metro area.
    Posts
    567
    Location
    MD,

    I'm confused.
    1. When I run the code, the Select a Cell dialog displays over wsDiag and not wsInfo (the source of data to be pasted into wsDiag).
    RJM: Perhaps, this is a place where I need to use the accursed Activiate method?
    2. If I select a cell on wsDiag (wrong sheet but only one 'available') the code detects that it's the wrong sheet and loops back to the dialog, creating a locked loop of sorts).
    3. Pressing Cancel bails me out of the Sub, as expected.
    4. The Move_Data function is accessed from within a WITH wsInfo block, so, how do we get wsInfo to display instead of wsDiag?

    5. Why does StdX start with 2? Isn't the first data cell of wsDiag on row 3? RJM: DOH! You increment before using, so StdX=3 the first time it's used.
    Last edited by RonMcK; 04-01-2011 at 08:10 AM.
    Ron
    Windermere, FL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •