Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VB Assigning Values to a Series of Strings
Hello,
In the VB Editor, I need to assign each letter of a 13 character string (named JobScope) to individual Variables (K1 through K13). I'm using a For/Next Loop to extract the indiv characters but cannot figure out how to define the Variable K(x) where x = 1 to 13. Any suggestions? -- Regards... |
#2
|
|||
|
|||
cincode5,
Try making K an array with 14 elements (VBA numbers the first element as 0) Then you can use the method you're trying at the moment. For X = 1 To 13 K(X) = etc. ~ ~ Next X The only other change you'll have to make is how you address the variables elsewhere. E.g, K5 will become K(5). Henry "cincode5" wrote in message ... Hello, In the VB Editor, I need to assign each letter of a 13 character string (named JobScope) to individual Variables (K1 through K13). I'm using a For/Next Loop to extract the indiv characters but cannot figure out how to define the Variable K(x) where x = 1 to 13. Any suggestions? -- Regards... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complete unknown values in series | Excel Discussion (Misc queries) | |||
Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
VBA error: Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
Chart -- How to chart 65536 values in 1 series? | About this forum | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel |