none
Error while using xlContinuous VBA

    Question

  •  

    Hello Everyone,

    Am getting the following error while using " .Borders.LineStyle = xlContinuous". This works fine in all system except mine

    Error Msg:

    Run-time error '1004'.

    Unable to set the lineStyle property of the border class

    Code:

      With CORE_GetRangeRef2(ws, ProjectView_Starting_Row, 1, LastRow, ColID - 1)
            .HorizontalAlignment = xlLeft
            .VerticalAlignment = xlBottom
            .Borders.LineStyle = xlContinuous
            .Font.Name = "Arial"
            .Font.Size = "8"
            .Interior.Color = RGB(217, 217, 217)
        End With

    Monday, July 25, 2016 6:46 AM

Answers