I am trying to apply a format style to a set of columns and to do that I am using
objWB.Worksheets(objWB.Worksheets.Count - 1).Cells.CreateRange("F:J").ApplyStyle(s1, New StyleFlag())
And when I debugg my application it takes alot to execute this instruction
my application crashes because it run out of memory I am wondering if the statment above is incorrect to achieve the goal of formatting columns F through J
s1 is actually
Dim s1 As Style = New Style
s1.Number = 14 'thas is mm/dd/yy;@"
I will appreciate any help