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

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

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)