How to find the last filled value cell address

I have ran the same code and it is printing right value, not sure why you are not getting it.

Let me out this variable instead of message box then just use that variable.

Try this
GetLastRow.xaml (8.2 KB)

Hi @sruthesanju ,

It may help you ,


It’s taking the whole excel last filled cell address
I need only for row no 1 which has period in A1

Getting some issue in invoke code.

I have create vba code, let me know if this works for you.

This will give you column number and address for row number 1

How to use in uipath should I need to write code in invoke code

You can put this in xlsm file and call macro function from execute macro activity.