Direction
type Direction = xlUp | xlDown | xlToRight | xlToLeft
Description
Specifies the direction of end in the specified range.
Try It
oWorksheet.GetRange("C4:D5").End("xlToLeft").SetFillColor(Api.CreateColorFromRGB(255, 224, 204));
type Direction = xlUp | xlDown | xlToRight | xlToLeft
Specifies the direction of end in the specified range.
oWorksheet.GetRange("C4:D5").End("xlToLeft").SetFillColor(Api.CreateColorFromRGB(255, 224, 204));