Macro to put a border in excel sheet

[amars]

Hi all,

I am writing a macro to export some object's in my chart to excel. I want to put border around the chart , I am writing a code like this

LastRow = MyTable.GetRowCount

XLSheet.Range("A1:A" & LastRow).BorderAround Weight=1

but it's not working. Anyone do have any idea how to put the border in an excel macro. If anyone could tell me that. Thank's in advance.

Regard's

Amar