View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PeterAtherton PeterAtherton is offline
external usenet poster
 
Posts: 42
Default Concatenate variables

Graham

Yes, the following returns 12345, prersumably as a string

Dim i As Long, s
For i = 1 To 5
s = s & i
Next
Debug.Print s

you would return it to a number with s = s * 1

Regards
Peter

"Graham Whitehead" wrote:

Hi,

I was just wondering if the following is possible in VBA:

suppose I have a collection of integer varaibles; called Integer1, Integer2.

Lets say these variables are used to count the occurance of particlaur
events which are also coded as integers from 1 to 5.

So the variable Code is set to evalue each one of these in turn.

Instead of saying if code=1 then integer1=integer1+1 etc.,
is it possible to use something in the form of Integer & Code=Integer & Code
+1.

I hope you see the point I am making and thus be able to tell me if it is
possible.

Many thanks.