Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate variables
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Concatenate | Excel Discussion (Misc queries) | |||
Concatenate two variables (String & Integer) | Excel Programming | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
how do you concatenate two variables in VBA | Excel Programming |