I want to create a multi-range. I have a list of range as string for example "A1:B2", "A5:B6", ...
and i want to create a ConditionalFormat on this multiRange but i don't know how.
I have try somethings but without success
- Code: Select all
var range = ws.Range["A1;B2;C3"]; // : 'Character ; was not expected.'
range = ws.Range["A1"].AddCombinedRange(ws.Range["B2"]); // return A1
Do you have a solution ?
Thanks