Name Box problems...

T

thelton

New Member
Joined
Sep 5, 2002
Messages
29
Probably simple, just couldn't find help on what I need. I have a sheet that I copied and it has NameBox references, I want to change 1 cell back to its cordinance...exp. NameBox = Total....I want it to be D4. And if you wouldn't mind telling me what the point of the NameBox is and where I can get more info on it.

Thanks

Trent
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
I'm not real sure if this is what you are looking for?
From your menubar Insert>Name>Define
Find your name and change the range reference.
Tom
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Need to create/source a macro/vba/program that auto populates info based on matching word criteria for community support agency
Replies
3
Views
489
Micron
M
P
  • Solved
Transferring data between two userforms problem .
Replies
7
Views
349
Pacman52
P
K
  • Question
Vlookup that copies formatting?
Replies
3
Views
472
Eric W
Eric W
gravanoc
  • Solved
Is my condition's syntax wrong or is this an Excel bug?
Replies
3
Views
406
gravanoc
gravanoc
N
  • Question
Stacked Chart to show value and status YTD
Replies
2
Views
410
neilo1969
N

Forum statistics

Threads
1,216,099
Messages
6,128,813
Members
449,469
Latest member
Kingwi11y

Share this page

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