Get the location of a variable from excel


#1

Hi guys,

I have a variable stored in an excel table, and i’d like to get it’s location (for example XZY is written into cell A3, and as a result I’d like to get cell A3). Can you help me with this one?

Thank you for your help,

P1


#2

Take Alphabets in Array - A B C D
Iterate the Array by use Read Cell till you get the Value and Cell Number.
else :


#3

Yeah, personally I would just find the row and column number within the datatable variable, then convert the column number to an alphabet character with vb expression.

Or another way is to use hotkeys inside Excel with Find til you select the cell, then Get Text of the address bar.

Thanks.