Named Range Import

mdjks

Registered User.
Local time
Today, 08:12
Joined
Jan 13, 2005
Messages
96
I have a named range in an Excel Spreadsheet called "ImportArea". Is there a way to import a named range in Access (2000). I can do each individually but I get errors when trying to get it all at once.


='Fee Matrix'!$A$5:$C$5,'Fee Matrix'!$A$8:$F$27,'Fee Matrix'!$A$31:$F$59,'Fee Matrix'!$A$62:$F$77,'Fee Matrix'!$A$81:$F$90,'Fee Matrix'!$A$94:$F$96,'Fee Matrix'!$A$101:$F$106
 

Users who are viewing this thread

Back
Top Bottom