I have the following code and I want to perform some things to every sheet after the first. And the first is called MU. It seems to be clearing ONLY the MU, which is basically the opposite of what I want.
Please Login or Register to view this content.
This is not efficient code, but it should do ( I have not tested it).
Probably do not need this line
.Columns("A:I").Select
Please Login or Register to view this content.
That worked but I now can't make it work with the existing (altbeit much more complicated) code. Any ideas? Again it does the exact opposite, running on the MU tab instead of all other tabs after it
This is how I tried to modify itPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Wheelie686; 06-11-2016 at 11:01 AM.
You need to use a "DOT" with With.
I have adjusted most of the lines, but not all of them as you have a call code.
Please Login or Register to view this content.
Last edited by AB33; 06-11-2016 at 11:36 AM.
Try this (not tested).
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
All these lines can be shortened toPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AB33; 06-11-2016 at 12:38 PM.
Both codes and my original attempt seem to highlight the same line of code. I did test what AlphaFrog gave me and it seems to have run the macro but only for sheet 2. It seems to have attempted it on Sheet 3 but stopped when it ran into that line.
Thank you AB33 for the Array code. I hadn't thought of doing it that way to make it cleanerPlease Login or Register to view this content.
Last edited by Wheelie686; 06-11-2016 at 02:08 PM.
You should include the error description as that could provide diagnostic info.
Need to reset rngDelRange for each worksheet otherwise it's trying to union ranges from different sheets and that throws an error.
Please Login or Register to view this content.
Thank you! I've been teaching myself VBA over the last little while and it's hard to know how to get around a problem until you end up finding out the hard way. Much appreciated AlphaFrog and AB33.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks