putting a name in the name box

  • Thread starter Thread starter donr5
  • Start date Start date
D

donr5

I have a worksheet that is quite large. I have a cell that is below the
viewing part of the worksheet when you first open a file. I woul dlike to put
a name of the information in the NAME BOX, that is just above cells A & B. I
have highlited the cell (A67) I want name, then put my cursor in the name
box, type in my name of the cell (250 service).When I hit the enter key, I
get an error message "you must enter a valid reference you want to go to,or
type a valid name for the selection". If I enter just "service" it will
accept it. Can I use the name " 250 service". Is it just a case of formating
the cell to accept the numbes in the name???? Open to ideas.

Thanks
Don
 
You can't have spaces in the name... maybe use an underline character
instead...

250_service
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Use worksheet name in one cell as part of reference in other cells 3
VBA - retrieve data on last create named range from previous inserted named range 0
Can't located named range 3
Use first day of month formula in a drop down list 3
shorten worksheet name 1
ambiguous name detected? 7
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top