collections

Actually, I am sure I just don't know how it works well enough to make it work, but hope the expertise here will be enough to correct my misdirection. I am using xlUnique to find unique values comparing two spreadsheets' keys. I copy the range from each sheet into a new worksheet to do the...

Hi, I have developed a workbook for estimating project costs based on selected Labour, Material, and Plant components, but I've recently dicovered classes and collections and was wondering whether they could be used to develop a more efficient solution. The data is multi-dimensional, i.e...

How can I store a lookup table in vbe module instead of a worksheet (hidden or visible). Is this possible? Or, could I pull the contents out of an existing lookup table, delete the workhseet, and have vba add a new worksheet and recreate the table? - Thank you, Rowland

hello, i have one questions, condition = 50 For Each l In ccc If l > condition Then l = l With aaa .Add Item:=l End With Else: l = l With bbb .Add Item:=l End With End If Next ccc is collection aaa and bbb is...

I'm trying to add values in a range to a collection. here's the range: <TABLE style="WIDTH: 103pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=137 x:str><COLGROUP><COL style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 5010" width=137><TBODY><TR...

Hi all When I try to add a UDT (defined using public type in the declarations section of a module) to a collection I get a compile error along the lines of 'Only user-defined types defined in a public object module can be coerced to or from...'. Am I doing something wrong or is it just that...