Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
amars
Specialist

Macro to put a border in excel sheet

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

0 Replies