Named range into string

GeeVeeGee · May 23rd, 2002, 02:44 PM

Hi all!
Can someone help me get the value of a named range (4 cells) in to a string variable.
thanks.

GeeVeeGee

Al Chara · May 23rd, 2002, 03:00 PM

Do you want the cell values to be an array of strings or just one big string?

GeeVeeGee · May 23rd, 2002, 03:57 PM

One big string

Al Chara · May 23rd, 2002, 04:07 PM

Try the following code:

Sub StringRange()
Dim MyString As String
Dim cell As Range
For Each cell In Range("MyRange")
MyString = MyString & cell.Value
Next
MsgBox MyString
End Sub

Change MyRange to the name of your range.

GeeVeeGee · May 23rd, 2002, 04:28 PM

OK thanks Al
I will give it a try

GvG

May 23rd, 2002, 04:07 PM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following code: Sub StringRange() Dim MyString As String Dim cell As Range For Each cell In Range("MyRange") MyString = MyString & cell.Value Next MsgBox MyString End Sub Change MyRange to the name of your range. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 02:44 PM	#1
GeeVeeGee New Member Join Date: May 2002 Posts: 6	Hi all! Can someone help me get the value of a named range (4 cells) in to a string variable. thanks. GeeVeeGee

May 23rd, 2002, 03:00 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Do you want the cell values to be an array of strings or just one big string?

May 23rd, 2002, 03:57 PM	#3
GeeVeeGee New Member Join Date: May 2002 Posts: 6	One big string

May 23rd, 2002, 04:28 PM	#5
GeeVeeGee New Member Join Date: May 2002 Posts: 6	OK thanks Al I will give it a try GvG