I have a excel in which the rows are not fixed I need to Highlight the borders to only the Rows which are filled for that instance . Either using Some activity or Vb.net Code . Without borders- [image] With borders- [image]

Hi @shashank_dullu Try this code: Sub HighlightFilledRows() Dim ws As Worksheet Dim lastRow As Long Dim rng As Range Dim cell As Range ' Specify the worksheet name Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet name ' Find the last row with dat…

Excel Borders using Vb.net Code in uipath

Help Studio

Yoichi (Yoichi) December 2, 2023, 2:56pm 5

Hi,

The following post may help you.

Regards,

Topic		Replies	Views
How do you set Excel borders on certain columns? Studio studio , question , activities_panel	9	560	April 9, 2024
Finding all available row and set border to them Studio	6	1333	April 7, 2022
How to add all borders to excel Help excel , studio , question	17	3990	December 23, 2019
How to give border by using uipath dynamically Automation Ops question , automation_ops	11	794	February 17, 2024
How to add border to Excel rows Help excel , activities , studio	15	8583	April 4, 2024

Excel Borders using Vb.net Code in uipath

Related topics