| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro error - cant work it out...
Dim icon As Variant
Dim myicon As Variant myicon = Array("icona1", "icona2", "icona3", "icona4", "icona5", "icona6", "icona7", "icona8", "icona9", "icona10", "icona11", "icona12") myref = Array("d3", "d4", "D5", "D6", "D7", "D8", "D9", "D10", "D11", "D12", "D13", "D14") I = LBound(myref) For Each icon In myicon Set myicon.Picture = LoadPicture("filepath" & Sheets("Sheet1").Range (myref(I)).Value & ".bmp") I = I + 1 Next icon --------------------------------- This works as Set icona1.Picture = LoadPicture("filepath" & Sheets("Sheet1").Range ("D3").Value & ".bmp") Set icona2.Picture = LoadPicture("filepath" & Sheets("Sheet1").Range ("D4").Value & ".bmp") etc.. So why not with the For statement... Any suggestions? Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
| On Error GoTo Doesn't Work | Excel Discussion (Misc queries) | |||
| DSUM gives a #VALUE! error and I can't work out why! | Excel Worksheet Functions | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Threaded Mode
