Error while using xlContinuous VBA

• Question

• 

  

  0

  Sign in to vote

   

  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

  • Moved by Dave PatrickMVP Monday, July 25, 2016 11:51 AM

  Monday, July 25, 2016 6:46 AM