Determine if named range is empty / null

Hi all,

This will probably turn out to be a really quick one: I've got some named ranges I'm working with that in of themselves use Offset to automatically expand a list.

Please Login or Register  to view this content.

How would I programatically determine if there's nothing in the range? I need to trap for instances where the users choose to work with the list, but haven't entered any items into it. E.g... (which obviously doesn't work!)

Please Login or Register  to view this content.

Cheers,
Bob

What happens when you type this in the Immediate window:

? Range("BrandList").Count

Yup. I was wondering if you would get "Object required".

Please Login or Register  to view this content.

Mmmm. That code was designed for a range that has had all its cells deleted. Stand by ...

try this (untested):

Please Login or Register  to view this content.