As question, I want to know is there any way to get multiple range in CellRange object like following:-
Since, I am doing a copy row function, but i need to copy the formula and style from the original row to multple range
xlSheet.InsertRow(wiStrRow, wiExpRow - 1);
CellRange waOrgRange = xlSheet.Range[xlSheet.Rows[wiStrRow].RangeAddress];
CellRange waNewRange = xlSheet.Range[xlSheet.Rows[wiStrRow].RangeAddress + "," + xlSheet.Rows[wiStrRow + wiExpRow - 1].RangeAddress];
xlSheet.Copy(waOrgRange, waNewRange);
Example, xlSheet.Range["A13:F13, A66:F66"], but it becomes error.
Anyone can tell me the correct syntax, Thanks a lot!