with worksheets("Sheet1")
strComp = .Range("B9").Value
End With
msgbox strComp

--
Regards,
Tom Ogilvy

"SHIPP" wrote in message
...
I would like to place the value of a specific cell into a variable. Does
anybody know how to do this?

Something like...

strComp=somecells value
--
M. Shipp