| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert string to variable
I have several variables named RandRow1, RandRow2, etc. that have been
populated with values. How do I convert a concatenated string into an actual variable? In this case it's RandRow & i where i = 1 to 10. Thanks. Dim RandRow1 as Long Dim RandRow2 as Long etc. With Sheets("writtentest") For i = 1 To 10 .Cells(i, "A") = Sheets("words").Cells(RandRow & i, "A") Next End With |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable string$ | New Users to Excel | |||
| setting a range variable equal to the value of a string variable | Excel Programming | |||
| How do I convert an integer variable to a string variable? | Excel Programming | |||
| Join string with variable name to get variable value | Excel Programming | |||
| VBA - Convert my variable range array to single cell string | Excel Programming | |||
Threaded Mode
