Excel Automation Bold and font

[Manish540 (Manish Shettigar)]

Hi @Shubham_Kinge ,

Check this below workflow,
Uipath_ApplyBorderAndBold.xaml (6.6 KB)

Files Used:-
BordersAndBold.txt (296 Bytes)
sample_input.xlsx (9.9 KB)

Code:-

Sub ApplyBordersAndBold(sheetName,Rng)

'Sheet on which you need to perform the opertaions
Sheets(sheetName).Activate

'Apply range of cells borders
ActiveSheet.Range(Rng).Borders.LineStyle = xlContinuous

'Make range of cells bold text
ActiveSheet.Range(Rng).Font.Bold = True

End Sub

If you are using vba macros for the first time then enable below settings in excel,

Hope this might help you