View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Executor Executor is offline
external usenet poster
 
Posts: 74
Default Referring to named ranges

Hi Hardy,

Try this:

Sub Update()
Dim FIData As Range
Set rngFIData = Range("FIData")
rngFIData.Select
:
:
End Sub

or this

Sub Update()
Range("FIData").Select
:
:
End Sub


Good luck,

Wouter