hey
just try making it this way

desc = Range("D9").Value

just assigning the value to it. i think it should work

-----Original Message-----
Hi all,

I'm trying to set a range value to a variable with the
following code:

Dim desc As String
Set desc = Range("D9").Value

I keep getting an "Object Required" error and can't for
the life of me figure it out. Any suggestions?




.