How to get cellName by index

Wed Oct 18, 2023 4:59 am

Hi..

In order to assign a formula to a specific cell, I need the cell name (A1, A2, B1,B2 ...) .
However,I did all the work by row, column index, I had to do complicated work to get the cell name.
( For example, after taking the ASCII code of A, adding it as much as the Row Index and converting it back to characters. )

Is there a way to get cell names directly by row and column index without doing this?

Wed Oct 18, 2023 5:38 am

Hi..

I found the attributes of RangeAddressLocal.
Sorry for reaching out when you're busy.
Have a great day!

Wed Oct 18, 2023 6:40 am

Hi,

Thank you for your inquiry.
I'm sorry for not replying to your message in a timely manner，if you have any issues in the future, just feel free to contact us.Wishing you a wonderful day.

Sincerely,
Ula
E-iceblue support team