Hello I really need some help with my coding in Excel 2007.
I have 80 worksheets in my workbook. I am trying to evaluate each sheet so that if there is a "Y" in a certain range of worksheets ("M" for Monday), then that sheet's data will be pasted to the sheet that begins with P (for prior week). There are 10 of these PW1, PW2, etc.
the code fails on the ElseIf line.
Please Login or Register to view this content.
Last edited by Leith Ross; 04-18-2013 at 01:54 PM. Reason: Added Code Tags
Hi
ws1 is not assigned anywhere.
rylo
Well Rylo, I'm not sure what you mean. I have ws1 setup in the Dim statement and the Elseif line. Do you have any suggestions as to how else to assign it?
Hello sarahcpa,
Welcome to the Forum!
The statement Dim ws1 As Worksheet creates a Worksheet Object variable. You must assign that object variable to an existing worksheet.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I'm still stumped. Tried to change the code up a bit, but now I'm getting "end if without block If" error.
pleeeeeease someone help meyou guys seem to think I know what I'm doing.
Please Login or Register to view this content.
Hi
Between your 2 end if statements, put in a next Dest. You haven't completed the for loop.
rylo
YAY
between your comments and more testing of individual pieces, I finally got it to work
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks