How to find the last filled value in a row and it's celladdress

Help Activities
1

I have to find last filled value in a particular row and it’s cell address using vbscript or vb.net

2

Hi, Use the below code, Check in import spaces “Microsoft.Office.Interop.Excel” being included. then use invoke code to execute this VB.Net code

Dim lastrow As Range = excel.Rows.End(XlDirection.xlDown)
Dim findrow As Range = excel.Range(“A1:A” & lastrow.row)