web discussions tasks blogs photos

[VBA - Excel] Can we get the cell address from range name?

kaka135 (3362) ranked 10 out of 65 in programming

3 years ago

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 = "Informat ion".

Is it possible for me to get the cell address, which is A1:A2 from the range name, which is "Informat ion"?

Thanks in advanced! happy

programming

sponsors

Local Electronic Stores

Find Local Electronics Stores& Get

yellowpages.com

Online Education

Choose From Top Computer Science/IT Schools. Earn Your Degree Online.

www.DegreesFinder.com

Checkmagic

Prints Quickenr Quickbooks checks on blank check paper.

www.checkmagic.com

User has not selected a best response.

respond to this discussion

tags:

computer, excel, vba

maygodblessu44 (3479)

3 years ago

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. thumbup

kaka135 (3362) ranked 10 out of 65 in programming	3 years ago
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?

maygodblessu44 (3479)	3 years ago
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.

Local Electronic Stores Find Local Electronics Stores & Get yellowpages.com

add comment

similar discussions

Is My Computer Suffering of Old Age??
My computer reached the old age of 6 years this autumn, and I´m beginning to wonder if I need a new...

I just bought my first external hard drive
I just bought an external hard drive for my computer. I have so many videos and files on my...

greateeeeeeeeeeeeeeesttttttttttttt revelution of the world
computer is the greatest revelution of the world.....without it we can live even a day.....we can...