non-contiguous range issue

[reneuend]

I'm building a range using Excel VBA that needs to skip one column. The rest are contiguous.

The range is dynamic, but in my test run it equals "F13:M13,O13:O13".
When I look at the values in this range it is only showing the values for F13:M13. Why doesn't it show O13:O13?

sRange = sCol1 & sRow & ":" & sCol2 & sRow & "," & sCol3 & sRow & ":" & sCol3 & sRow
            
Set InputRngB = ActiveWorkbook.Worksheets(TEST_TAB).Range(sRange)

Thanks for replying!

 

[reneuend]

Thanks Dean. I actually wasn't using the Copy / Paste option when I wrote my code. I had a "named range" the same size as the non-contiguous range that I created. Then I just set the named range equal to the non-contiguous range.

worksheets("mysheet").range("myrange").value = noncontiguous_range.value

Since this doesn't seem to work though, I'll review and learn how your code works.

I wonder why they haven't fixed this in the newer versions of Excel? It seems like something that would be a common issue.

much appreciated,
~reneuend