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 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
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.