Hi,

I did an insert -- name -- define: a range that would automatically update:

RangeName = "Sheet2!$C$4:$Q$"&COUNT(Sheet2!$E$4000)+3

So I want to write a macro that uses the range.
x = Range("RangeName").Value
gives the following error:
Method Range of Object Global Failed

when i set a range in the worksheet using the upper left hand box the macro
works.
Do you know how to fix this problem.

Thanks