Sign in
Microsoft.com
 
Microsoft
 
 
 

none
Error while using xlContinuous VBA

 > 

    Question

  • Question
    Sign in to vote
    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

    Monday, July 25, 2016 6:46 AM
    |

Answers