Easy String Question

spaceherbie · Apr 18th, 2002, 08:54 AM

This is my first day at trying to write VBA macros, so sorry for the newbie question.

Lets say I have a string,

Dim text As String

and cell A1 happens to have the number 123 in it. How do I read that cell in the middle of the string so it reads for example "thenumber123isinthecell"? Thanks in advance.

Ricky Morris · Apr 18th, 2002, 08:59 AM

Try:
text = "thenumber" & cells(1,1).value & "isinthecell"

Asala42 · Apr 18th, 2002, 08:59 AM

G'day,

I'm new to vba also, but do you mean something like (?):

Text = "Thenumber" & Sheets("Sheet1").Range("A1").Value & "isinthecell"

Adam

Apr 18th, 2002, 08:59 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try: text = "thenumber" & cells(1,1).value & "isinthecell" __________________ It's never too late to learn something new. Ricky

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

Apr 18th, 2002, 08:54 AM	#1
spaceherbie New Member Join Date: Apr 2002 Posts: 3	This is my first day at trying to write VBA macros, so sorry for the newbie question. Lets say I have a string, Dim text As String and cell A1 happens to have the number 123 in it. How do I read that cell in the middle of the string so it reads for example "thenumber123isinthecell"? Thanks in advance.

Apr 18th, 2002, 08:59 AM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	G'day, I'm new to vba also, but do you mean something like (?): Text = "Thenumber" & Sheets("Sheet1").Range("A1").Value & "isinthecell" Adam