PC Review


Reply
Thread Tools Rate Thread

Concatenate Variables

 
 
hmiller@hartford.edu
Guest
Posts: n/a
 
      18th Dec 2006
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

 
Reply With Quote
 
 
 
 
hmiller@hartford.edu
Guest
Posts: n/a
 
      18th Dec 2006
Thank you much, Alok. Worked Great!

 
Reply With Quote
 
hmiller@hartford.edu
Guest
Posts: n/a
 
      18th Dec 2006
Thank you much, Alok. Worked Great!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate Variables in VBA Don Microsoft Excel Discussion 2 29th Jul 2009 07:20 PM
Concatenate variables Graham Whitehead Microsoft Excel Programming 1 2nd Oct 2006 02:28 PM
how to concatenate two variables =?Utf-8?B?UGhpc2g3Ng==?= Microsoft Access Queries 3 20th Sep 2006 01:34 PM
Concatenate Variables John Microsoft Access Form Coding 1 2nd Jun 2004 02:26 PM
how do you concatenate two variables in VBA billabong Microsoft Excel Programming 1 26th Sep 2003 12:30 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:26 AM.