Peter,

Thanks for your help. Unfortunately this still does not work. I get
the following error.

Run-tine error '1004'

Method 'Range of object '_Global falied

I also tried to set the range in the same procedure, but I still got
the same error. (I had been getting the value from a function earlier)

I'll keep trying. Thanks again for your help!