1

Resolved

Error resolving named range

description

If a named Excel cell/range is located on a worksheet whose name contains a hyphen (-), the range address cannot be resolved correctly. Instead, the Range.Start property bombs out with an exception (invalid row number -1 or similar). I.e. this will not work: "ASI-Sheet!$B$2", whereas this will: "ASISheet!$B$2", despite the fact that both names are valid in Excel. I haven't tried other char combos (blanks and/or underscores), but please fix at your earliest convenience.

comments

richardtallent wrote Aug 10, 2012 at 7:32 AM

It's just a stab in the dark, but try handling the reference as you would in a formula:

'ASI-Sheet'!$B$2

(With the apostrophes.)

JanKallman wrote Aug 31, 2012 at 6:54 AM

Try latest source