Excel Activity - Get current cell reference

excel
activities
studio
#1

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?

#2

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
#3

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

image

1 Like
#4

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

#5

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

1 Like