Hello everyone, Please, I need help in finding the last row with data in an Excel sheet. I am writing some values into my excel sheet dynamically, and need to determine the last empty row so as to append the new values. I have tried the “Find First/Last Data Row” actitivity but this does not work …

[image] Emmy_O: Sub sblastRowOfASheet() Dim LR As Long 'For understanding LR = Last Row LR = Range(“A:L”).SpecialCells(xlCellTypeLastCell).Row MsgBox LR End Sub @Emmy_O , Could you change the code to the below and check : Private Function sblastRowOfASheet() Dim LR As Long 'For unders…

Find last row with data in Excel

Help Studio

Sudharsan_Ka (Sudharsan Ka) July 5, 2022, 6:44am 7

Hi @Emmy_O

Checkout this thread

hope this helps

Regards
Sudharsan

1 Like

Topic		Replies	Views
Get last row activity problem Studio excel , studio , question	4	300	December 25, 2023
StudioX - Find Last data row in excel file Help studiox , question	10	4795	December 6, 2020
How do I get the last value in Column A? Learn excel	17	5084	June 22, 2020
Get last column with row value Studio	6	6213	March 21, 2022
Read last row excel and write data in other excel Activities excel , activities , question	8	1756	April 24, 2021

Most Active Users - Yesterday
ashokkarale
lrtetala
postwick
Julian_Muhlbauer
Yoichi
Ajay_Mishra
Anonymouss
vrdabberu
ABHIMANYU_THITE1
anjani_priya
More details...

Find last row with data in Excel

Related Topics