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

RK_0 (RK) July 5, 2022, 6:45am 8

Hi,

Check this post

Contains same requirement

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

Most Active Users - Yesterday
sonaliaggarwal47
A_Learner
sharazkm32
More details...

Find last row with data in Excel

Related topics