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