Copy noncontiguous range of cells to another sheet

I am using the following code to copy specific column cells to another sheet:

Please Login or Register  to view this content.

I am trying to use the below code to select the specific cells, but it selects the entire range from B to D that also includes C column, whereas i need only B and D column. Is there any way to achieve this? Please suggest the changes (also i am looking for a general solution where where we can achieve this for any number of noncontiguous cells):

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

@Andrew-R: Whoa! That was quick!! Thanks a ton bro! Finally its working!!