Selecting non adjacent ranges with variables

[t3chn0babbl3]

I am trying to select rows based on a cell value greater than 0 and for those rows, selecting columns A through E and I through S. What is the proper way to select non adjacent ranges?

Please Login or Register  to view this content.

[t3chn0babbl3]

Took me a while, but I figured it out. In case anyone searches and wants to know:

Please Login or Register  to view this content.

[D_Rennie]

hello,

congrats on getting the answer you where looking for.

the code for the border can be done in one line.

Please Login or Register  to view this content.

cheers