Are you sure that it is not that column B has no numbers?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rob" wrote in message
...
Hi,

I have a dynamic range name set as MyProd, I used
=OFFSET((sheet1!$B$5,0,0,count(sheet1!$B:$B),5) in the Names menu to
define this. However, since setting this up, the Macro I had that looked
up data in a column from the range MyProd, returns errors as if the range
address isn't known. Is there as solution to resolve this eg. somehow
define the address before running the macro?

Hoping someone can give some direction.

Thanks, Rob