Conditional Formatting icon change type problem

[Stephen Plotnick]

I'm building an Excel 2007 spreadsheet via VB 2005 and I'm trying to do some
conditional formatting with icon sets

I'm able to create an icon with the Green or Red traffic light (this must be
the default). When I try to change to the 5 arrow the VSE does not flag my
code as an error but at run time I get the following message.

Public member iconsets and type worksheet not found.

Here is the code to change the iconset.

cfIconSet.IconSet = osheet.IconSets(XlIconSet.xl5Arrows)

THanks,
Steve

 

[Stephen Plotnick]

I figured out the problem.

In case someone else needs this I'm refencing the sheet and need to
reference the book.

Steve