I have a problem using named ranges when using the TransferSpread.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem using named ranges when using the TransferSpread function in
Access. It gives me "Can't find object error".When I use ranges like A1:B1 it
works fine.The problem is that I can't change all the ranges every time
something changes in the spreadsheet. Is there a certain way of entering a
named range?
 
Any chance you are using"funny" characters in your range names?
Alphanumeric, spaces, dashes and underscores will work fine, anything
else is a gamble!

HTH,
Nikos
 
Hi Ferdinand,

In case Nikos's suggestion didn't fix it:

I presume that when you use "ranges like A1:B1" you're actually
specifying the worksheet name as well. Don't specify the worksheet name
with named ranges, unless they are sheet-level names rather than
workbook-level ones.
 
Back
Top