[VBA - Excel] Can we get the cell address from range name?
By Lee Ka
@kaka135 (14916)
Malaysia
October 12, 2009 10:51pm CST
I'm working on a task using VB6, which I have defined the name in the Excel file, say it's range from A1:A2, name = "Information".
Is it possible for me to get the cell address, which is A1:A2 from the range name, which is "Information"?
Thanks in advanced! 
1 person likes this
1 response
@maygodblessu44 (7336)
• India
26 Nov 09
Hello my friend kaka135 Ji
Well, I am very sorry to dis-appoint you as I amnot that expert, but after I discuss with my Children who are as in this field,I may find some suitable repy for you. May God bless You and have a great day. 
1 person likes this
@kaka135 (14916)
• Malaysia
1 Dec 09
Hi there, thanks very much for your help!
Actually I've found the solution, and get the work done some time ago. It can be done by just calling Range("DefinedName").Column & Range("DefinedName").Row to get the cell address.
Your children are working in IT field as well?
1 person likes this
@maygodblessu44 (7336)
• India
1 Dec 09
Hello my friend kaka135 Ji,
Wow! So you alraedy found the solution to your problem, before I could discuss with my children. They do belong to IT field, but living far away from us right now. We live at our own country house.
May God bless You and have a great time.
