Hi,

What is best practise in referring to named ranges in VBA? I have
dynamic named ranges in Excel which I wish to refer to in VBA.

Sub Update()

Dim FIData As Range

Set rngFIData = Range("FIData")

Range("rngFIData").Select

End Sub

I get runtime error on the last line. The range name "FIData" is valid
in the sheet. Again, I am not sure I am following best practise, but my
experience is that somtimes it appears to work in some workbooks and not
others...

Thanks


--
Hardy
------------------------------------------------------------------------
Hardy's Profile: http://www.excelforum.com/member.php...fo&userid=3163
View this thread: http://www.excelforum.com/showthread...hreadid=398985