| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatanate variable name
I got four control on an userform named Date1, Date2, Date3 and Date4.
I am trying to fill them in with this small macro, it doesn't work because my concatenation doesn't seem to be properly set up... Sub Test For i = 1 to 4 Date & i &.value = Range("A" & i).Value Next i End Sub I got an error for "Date & i &.value", any idea how to solve this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATANATE | Excel Worksheet Functions | |||
| Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
| variable height variable width stacked bar charts | Charts and Charting in Excel | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Formatting range in concatanate | Excel Discussion (Misc queries) | |||
Threaded Mode
