| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referring to increasing VBA variable name in loop
It worked fine for me in xl2003.
Alan Beban wrote: wrote: I guess great minds think alike since everyone recommended the array, thanks! I make no claim for its utility, but I'm curious whether the following works (I don't have a more current version of xl): Sub abtest4() Names.Add Name:="phrase1", RefersTo:="Hello" Names.Add Name:="phrase2", RefersTo:="Goodbye" For i = 1 To 2 XL.Speech.Speak Evaluate("phrase" & i) Next End Sub -- Dave Peterson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referring to increasing VBA variable name in loop
If I change the XL reference to Application, then it works in XL2007 also.
Rick "Dave Peterson" wrote in message ... It worked fine for me in xl2003. Alan Beban wrote: wrote: I guess great minds think alike since everyone recommended the array, thanks! I make no claim for its utility, but I'm curious whether the following works (I don't have a more current version of xl): Sub abtest4() Names.Add Name:="phrase1", RefersTo:="Hello" Names.Add Name:="phrase2", RefersTo:="Goodbye" For i = 1 To 2 XL.Speech.Speak Evaluate("phrase" & i) Next End Sub -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referring to increasing VBA variable name in loop
Rick Rothstein (MVP - VB) wrote:
If I change the XL reference to Application, then it works in XL2007 also. Rick Thanks for the feedback. Alan "Dave Peterson" wrote in message ... It worked fine for me in xl2003. Alan Beban wrote: wrote: I guess great minds think alike since everyone recommended the array, thanks! I make no claim for its utility, but I'm curious whether the following works (I don't have a more current version of xl): Sub abtest4() Names.Add Name:="phrase1", RefersTo:="Hello" Names.Add Name:="phrase2", RefersTo:="Goodbye" For i = 1 To 2 XL.Speech.Speak Evaluate("phrase" & i) Next End Sub -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referring to increasing VBA variable name in loop
Dave Peterson wrote:
It worked fine for me in xl2003. Thanks for the feedback. Alan Alan Beban wrote: wrote: I guess great minds think alike since everyone recommended the array, thanks! I make no claim for its utility, but I'm curious whether the following works (I don't have a more current version of xl): Sub abtest4() Names.Add Name:="phrase1", RefersTo:="Hello" Names.Add Name:="phrase2", RefersTo:="Goodbye" For i = 1 To 2 XL.Speech.Speak Evaluate("phrase" & i) Next End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to a variable file name | Excel Discussion (Misc queries) | |||
| Referring to multiple worksheets via a variable | Excel Programming | |||
| Referring to a Worksheet with a variable | Excel Programming | |||
| Increasing a range in a loop | Excel Programming | |||
| Referring to a worksheet using variable | Excel Programming | |||
Hybrid Mode
