View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orlando Orlando is offline
external usenet poster
 
Posts: 16
Default Question about named area

HI, I have created several named areas in an Excel SpreadSheet, my cuestion
is, in VBA programming how can I make reference to these diferent areas in a
dinamic way.

Let say I have a worksheet whith several concepts repeated several times,
each concept is a named area. example

Salary 1500
Groceries 200
movies 30
Groceries 50

my question is how can I in VBA read Salary and add 1500 to the named area
Salary, and after Groceries, movies, etc.

If somebody can help me I would appreciated.

Thanks