Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create N variables
I have a piece of vba code which can be simplified to
Dim Piece As Picture For Each Piece In ActiveSheet.Pictures ****** ****** ****** Next Piece Within the piece iteration I wish to retrieve some information about each picture and store it as a variable i.e. variable(1.....n) = Piece(1.....n).topleftcell. I am unsure how to automatically generate variable sequence to the correct number of variables. i.e. so that it stores a new variable and value for later use off of each loop. VBA is amusing, there is always something new to learn and when you do you only have another two things to learn afther that so please help. thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a Excel bar chart with 3 variables? | Charts and Charting in Excel | |||
Create possible combinations from three variables | Excel Discussion (Misc queries) | |||
Is it possible to create variables in a loop.. | Excel Programming | |||
Create Message Box containing different variables. | Excel Programming | |||
Create Global Variables in a module | Excel Programming |