How do I assign the value in say cell a3 to a string named QuoteNumber?

oldjay

Dim QuoteNumber as string
QuoteNumber = "A quote number here"
activesheet.range("a3").value = QuoteNumber

or did you want to put the value in A3 into QuoteNumber?

QuoteNumber = activesheet.range("a3").value

Oldjay wrote:

How do I assign the value in say cell a3 to a string named QuoteNumber?

oldjay

--

Dave Peterson

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