Macro for Border

[sunny_talwar]

Hi Team -

Working on a Macro to assign a border to a particular cell. The Macro is as follows

Sub Macro1()

    Range("C12").Select

    With Selection.Borders(xlEdgeTop)

        .LineStyle = xlContinuous

        .ColorIndex = 0

        .TintAndShade = 0

        .Weight = xlThin

    End With

    With Selection.Borders(xlEdgeBottom)

        .LineStyle = xlDouble

        .ColorIndex = 0

        .TintAndShade = 0

        .Weight = xlThick

    End With

End Sub

This seems to work in Excel, but fails to work in QlikView's VBScript.

Will try to create a sample to show my issue.

marcus_sommer‌, tamilarasu‌, phaneendra.kunche‌

Best,

Sunny

[sunny_talwar]

tamilarasu‌, marcus_sommer‌

I made a slight mistake when I was implementing Tamil's code. After the changes that Marcus mentioned, Tamil's code worked and so did my code. Mistake I made was following

Set Rng = XLSheet.Range("C12").Select

Left the .Select at the end of this.