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

kaka135 (2768) ranked 21 out of 94 in programming

2 months 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

Braun® Series 3 Shaver

Goodbye Weekend. Hello Smooth Skin. Buy Braun®'s Series 3 Shaver Today.

www.Braun.com/Series3

Massage Envy - Meyerland

Read this Massage Therapist's reviews& find Personal Services

Houston.Citysearch.com

Merkur merkur double edge safety razor blade Razors& Blades

Fine German merkur double edge safety razor blade Razors, Blades, Brushes and Soaps Fast Shipping.

www.NashvilleKnifeShop.com

User has not selected a best response.

respond to this discussion

tags:

vba, excel, computer

maygodblessu44 (2398) ranked 39 out of 94 in programming

3 weeks 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 (2768) ranked 21 out of 94 in programming	1 week 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 (2398) ranked 39 out of 94 in programming	1 week 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.

Braun® Series 3 Shaver Goodbye Weekend. Hello Smooth Skin. Buy Braun®'s Series 3 Shaver Today. www.Braun.com/Series3

add comment

similar discussions

How create in macro in microsoft excel?
With macro you are able to automate your daily routine job. In order to do that you can use record...

Now the Class is Open for Excel User.
If you have any question about VBA code or Excel pls do so. I will try answer U ASAP.

Learn Excel VBA Macros Ebook
IF anyone requires a great book on learning Excel VBA macros to automate their work in Excel,...