Method range of object global failed

**darahsten** · 01-28-2013, 03:23 PM

Hi all,
I am stuck with this error above named in the row below with arrows

Please Login or Register  to view this content.

From what i read this error usually comes when the named range is involved is invalid. In debugging i proved that this is actually the problem. Because replacing the "instore_qtty" with another named range did result in same error
the "instore_qtty" is a named dynamic range on the sheets "Production records"
I have apparently failed to see what the problem is with the naming of the range
Below is the actual synatx for the dynamic range "instore_qtty"

Please Login or Register  to view this content.

If anybody can advise me how to proceed i will be very glad.
Stephen

**Norie** · 01-28-2013, 03:28 PM

Stephen

Are there any values in H:H on 'Production Records'?

**darahsten** · 01-28-2013, 10:40 PM

Thanks Norie, there areant any values. I have also tried filling the column with sample data 0,0,7 before and my attempts still went begging

**Norie** · 01-28-2013, 10:59 PM

If there's no data in the column then the COUNTA function will return 0 and the formula for the named range will fail.

I would have thought entering values should work, though it might depend on where you entered them.

Could you upload a sample workbook? Then we might be able to see what's happening.

**darahsten** · 01-29-2013, 12:06 AM

Thanks Norie again so much for the quick one there.
I managed to smoke out the problem. Initially it was the lack of data that caused the name to fail. However in my attempt to try to get things to work i redefined the range several times lastly as "instore_Qity" instead of "instore_qtty". when i tested the range with data the rangename was invalid.
I corrected that and now when i test with data i get no error and without data i get dreaded error.
Thanks for your very smart explanation. I am yet to understand using the offset function to name dynamic ranges properly.
Best Regrads
Stephen