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
Finding all available row and set border to them Studio	6	1236	April 7, 2022
How to add border for excel range in sheet Studio studio , question , activities_panel	7	1619	April 5, 2024
How to add border to Excel rows Help excel , activities , studio	15	8402	April 4, 2024
Set Border to excel sheets without external packages \|\| Without Excel scope \|\| Closed XML Tutorials excel , activities	2	2589	April 4, 2024
How to create cell border lines in Excel using VB code Certification excel	1	1591	December 4, 2020

Most Active Users - Yesterday
ashokkarale
Yoichi
Anil_G
sudster
Kismet_Tosun
anand.t
k.sakaguchi0804
SorenB
Akash_Javalekar1
Sisay_Dinku
More details...

Excel Borders using Vb.net Code in uipath

Related Topics