View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default How to reference a named area

try:
MsgBox Range("Salary")(1, 1).Value
MsgBox Range("Salary")(4, 2).Value


"Orlando" wrote:

HI, programming in excel VBA, how can I make reference to and area I define,
example I name the area D5 to F10 and I call it Salary, how can I read the
information in the cell D5 or E8 from VBA.

Thanks.