Find cell with String Value and get no. of row, name of column

[AKY (KyNhongDiMua)]

Hi @arivu96
Hi @Divyashreem

Until now i can get number of row, name of column by this way:

How to put variables into the function with "invoke VBA"?

Hi all, I am using the VB function to search the cell address in excel. This is my program VBA: [image] Some function is ok like FindAddressOfActiveCell(). But when using a function that has variable values put in is not good. I tried many times but failed. [image] Please help me in learn. Thank all.