G Guest Jul 29, 2007 #1 How do I assign the value in say cell a3 to a string named QuoteNumber? oldjay
D Dave Peterson Jul 29, 2007 #2 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
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
C Chip Pearson Jul 29, 2007 #3 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)
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)
