J
Joey
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
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