Excel Shortcut Key for Name Box

FlowerGirl

New Member
Joined
Dec 10, 2008
Messages
6
I would like to be able to capture the cell address in the Name Box and use it as the beginning address of a range I want to copy. How do I get to the Name Box to copy that information?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
For a vba macro or in interactive session?

You can click in it and copy it.
 
Upvote 0
I do not know how to do macros. What I want to do is program the shortcut key strokes into an AutoMate program.
 
Upvote 0
Hey Flower Girl, what about the CELL formula?

I'm not totally sure I understand what you want, is that on the right path?
 
Upvote 0
bk,
That would work if I knew how to refer to the Name Box. =Cell(Name Box) doesn't work. As soon as I type = in a cell, the Name Box changes to SUM and if I click on it, I get the Function Arguments dialog box.
 
Upvote 0
Can you give some example data?

Exactly what's in a sample cell.

Exactly what you want to capture.

And what you mean by "capture"? Capture where, to do what with next

Also what do you mean by "name box", the little place where it puts the named range, cell reference or whatever that's active? Usually in upper left corner above A1?

Pardon me for being a little slow, but I can actually be useful sometimes :) once I grasp what somebody's wanting.
 
Upvote 0
bk, yes, the "cell" that is directly above A1. What I want to do is:
Ctrl+F a specific text string. The cell number of that text string in now in the Name Box. Then, I want to be able to go to the Name Box and copy (capture) that cell address (for example: M72) so I can later use it as the beginning address of a range of data I want to copy.
Did that make sense?
 
Upvote 0
It made a little more.

The "name box" is nothing more than the address/named-range of the active cell really. So, unless you are absolutely certain that you MUST have the name box, I think we can get you what you want a different way.

This can be done probably more than one way, but via a Macro that uses Target or ActiveCell would probably be the best.

So, assuming that "captures" it properly, what, when and how are you going to use it? That may influence exactly how we get it or what we do with it.
 
Upvote 0
I think I may have a way to get the info I need. After I do my Find, I'm in the cell I want the address of. If I do =Column(), put that information into a variable, move right one cell, do Row(), put that infor into another variable, then do =Address(var1,var2) and put that into a third variable, I get an answer I can work with. I can then close without saving, open back up and goto the address in Var3. I can get the ending location the same way.
Did I mention I don't know how to do macros yet?
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top