Thread: Dumb Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Dumb Question

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