How to select multiple ranges in VBA?

[buhaj47]

I want to have three groups of cells checked

Please Login or Register  to view this content.

and cleared

Please Login or Register  to view this content.

With that range though, a compile error appears. How to define the columns in question so that VBA code recongnizes them?

[Patronus]

Hey, Try to do it without quotation marks:

Please Login or Register  to view this content.