Excel Automation Bold and font

i want to bold the headers give all table as grid lines and provide same Font. do some one know how can i do it.
Thanks

Hi @Shubham_Kinge

Check out this thread and document

Regards
Gokul

1 Like

Hi @Shubham_Kinge

Please try this

Hope this might help you :slight_smile:

5 Likes

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,
image

Hope this might help you :slight_smile:

8 Likes

@Gokul001 @Manish540 @Pavanraj_Shetty
Can someone give me the code of macro which input should be like - range like A1:K100
and can change whole sheet font to times new roman, should bold the headers and last row. need to auto adjust the full columns and gridlines should be invisible with A1:K100 as full borders.

Thnaks in advance

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.