[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Concatenate Variables

hmiller@hartford.edu

12/18/2006 7:12:00 PM

Hey folks,

I'm wondering if you could help me out here. My overall goal is to loop
through a set of string variable that I have defined in my code, and
display these strings on a worksheet. Something like this:

Dim hello1 As String
Dim hello2 As String

Hello1 = "Hey"
Hello2 = "What's Up"

For i = 1 to 2
Sheets(1).Cells(1, i).Value = Hello & i
Next i

If you know of another way to loop through variables stored in code I'm
all ears. I'm new to all this.

Thanks in advance,

HMiller

2 Answers

hmiller@hartford.edu

12/18/2006 7:48:00 PM

0

Thank you much, Alok. Worked Great!

hmiller@hartford.edu

12/18/2006 7:48:00 PM

0

Thank you much, Alok. Worked Great!