Exclude certain cells

I have tried to find a solution to exclude certain cells in a range all over the place but I still haven't found what I am looking for. Maybe someone here can help me?

The point is to exclude C20:C21, C33:C34 etc from the fillrange below (C9:C122) and I guess there is a very simple solution for the problem?

Please Login or Register  to view this content.

Another problem I have is how to include several sheets into this?

Please Login or Register  to view this content.

I want to write it like this, but this isn't working:

Please Login or Register  to view this content.

Any ideas?

Thanks in advance!

First of all, to take care of different worksheets, I would either loop over all worksheets or if you have just a few, define just a few worksheets as such (assuming they're in the same workbook as the code)

You can loop over all worksheets if you declare a WS variable (Dim WS As Worksheet) with the following For -- Each structure:

Please Login or Register  to view this content.

Declaring Worksheets individually:

Please Login or Register  to view this content.

Then, to exclude certain ranges, I would use the Union function. Something like:

Please Login or Register  to view this content.

Remember, when you need to access fillRange (avoid .Copy/.Select/.Paste methods), you need to account for areas within the fillRange object because If you, say copy that range over to WS_MB2 in column 1, you'll need to loop over areas with a structure similar to:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

joe31623, please do not post to a thread with a rule violation, even if a Moderator has not flagged that violation.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

6String: No problem; I apologize.