dear support,
Hi,
thanks for looking into it.
Hi,
Dim rangeName As String = “‘My’’’’’’ Sheet’!$C$2:$C$11”
Dim splits As String = rangeName.Split(New String() {"!"}, StringSplitOptions.None)
Dim sheetName As [String] = splits(0).Replace("’’", “’”).TrimStart(New Char() {"’“c}).TrimEnd(New Char() {”’"c})
Dim rangeCells As [String] = splits(1)
Dim sh As Worksheet = wb.Worksheets(sheetName)
Dim rng As Range = wb.Worksheets(sheetName).Cells.CreateRange(rangeCells)
Debug.WriteLine(rng)
string rangeName = “‘My’’’’’’ Sheet’!$C$2:$C$11”;
String[] splits = rangeName.Split(new string[] { “!” }, StringSplitOptions.None);
String sheetName = splits[0].Replace("’’", “’”).TrimStart(new char[] { ‘’’ }).TrimEnd(new char[] { ‘’’ });
String rangeCells = splits[1];
Worksheet sh = wb.Worksheets[sheetName];
Range rng = wb.Worksheets[sheetName].Cells.CreateRange(rangeCells);
Debug.WriteLine(rng);
Ok, good to know that my approach is correct.
Hi,