Do something like

QuoteNumber = Range("A3").Text ' or .Value

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Oldjay" wrote in message
...
How do I assign the value in say cell a3 to a string named QuoteNumber?

oldjay