View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default What is worng with my formula?

On Wed, 22 Aug 2007 04:50:01 -0700, robert morris
wrote:

Ron,

O.K., as a beginner, where do I start to find and enter:
Insert/Name/Define RNG

Names in Workbook: RNG
Refers to:=$I$12,$M$12,$Q$12,$U$12,$Y$12,$AD$12,$AH$12,$A L$12,$AP$12

Is the above entered as a Macro?

Continued help is appreciated. Help me out of this and I won't bother you
further on this matter.

Bob


On the top bar of Excel (actually the 2nd from top, there are a number of
"Menu" options -- File Edit ...

One of those options should be "Insert"

If you click on "Insert" it opens a dropdown menu. One of those items in the
dropdown menu is "Name"

If you then click on "Name", one of the submenu items will be "Define"

If you then click on "Define" it will open a Dialog box where you will see, and
can fill in, the information.
--ron