I have a worksheet(Morning Reports) that has a running macro on what I need is how do I get this same code to work on a different sheet titled (Afternoon Reports) This afternoon report will be a scaled down version with slightly different range:
How do I modify this code to do the same thing just on a different sheet
Please Login or Register to view this content.
I also attached the worksheet if anyone needs it to look at.
Protection password is "Financial3" and sheet and VBA
Last edited by bdouglas1011; 08-06-2014 at 03:12 PM. Reason: Revised question to show code
Have you tried replacing "Morning" with "Afternoon"??
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Yes I changed all my Subs to have the Number 2 after so it was like a new Macro, then I changed every Morning report to afternoon report, but I kept getting a error when the macro got so the input question.
I got error with the retval line: so I added " ' " infornt of all of them and tried to rerun and not have the question then I got a new error:Please Login or Register to view this content.
it highlighted the olByValue, 0 on the attachment line.Please Login or Register to view this content.
I then deleted "olByValue, 0" - now it is seem to run OK but I am not sure why my question quit working from one sheet to the other.
any suggestions.
does nothing?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