Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A small correction
Use an array. Dim arrPI Dim intTemp arrPI = Array("a","b","c","d") For intTemp = 0 to Ubound(arrPI) Msgbox arrPI(intTemp) Next If you want to assign variables at run time declare Dim arrPI(10) as Variant arrPI(0) = "Something0" arrPI(1) = "Something1" arrPI(2) = "Something2" arrPI(3) = "Something2" .. upto (You can store a max of 11 variables in this array) arrPI(10) = "Something10" If this post helps click Yes --------------- Jacob Skaria |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert Variable Number of Rows; With Loop | Excel Worksheet Functions | |||
Loop Macro a variable number of times | Excel Discussion (Misc queries) | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
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 |