Excel Activity - Get current cell reference

Hi,

What do you think about a new Excel activity that allow you to get the location of the active/selected cell (for example E15) as a string?

You can invoke a vb code that does this.

Or iterate in a for each row to find the cell you need or content.

But its an idea that would work!

Kind Regards

1 Like

You can use the LookUp Range activity to return the cell reference of a particular value in an Excel workbook:

image

2 Likes

Thank you, its a good idea i didn’t know that :hugs:

This package has GetActiveCell which might be useful alongwith other activities.

2 Likes