-
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
-
Forum Rules