Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a dictionary, named dictCornerCellPics, whose items are all
picture objects. I want to loop through each picture's name (not key!) and if it satisifies a condition, the code does something. This below gives the gist of what I want to do, but doesn't work. dim pic as Picture dim picName as string For each pic in dictCornerCellPics picName = pic.name if picName like "UL*" then 'does some stuff end if next pic This code also returns an error if I use dictCornerCellPics The code above returns an "Object Required" error. Anybody know what's wrong with the above code, or can give a better/different way to achieve the same thing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Customizing a dictionary | Excel Worksheet Functions | |||
HELP-Dictionary | Excel Programming | |||
dictionary | Excel Programming | |||
Dictionary objet | Excel Programming |