Named Range
 

Hi

How do I set a named range in Excel from access?
When I used the auto macro, it gave me two entires of the
following line:

ActiveWorkbook.Names.Add Name:="Data",
RefersToR1C1:="=Sheet1!R1C1:R6C23"

but when I run the code, it gives me an error at that line.

Please help
TIA
Joey