Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
processing part of a collection
hello,
This is the next step in the last code i posted. I looks at a rang and makes the cell values items in a colection. THen thing i can' seem to do now is process the items. each item is test to see if it has a length less than four if it doe than its supposed to add "0" to the front the item until it has length of four. the problem occurs when it get to a line that reads: COL1.Item(I) = 0 & COL1.Item(I) it gives me a runtime error highlighting that line and says objec required. I can't think of an object to put in there here is the whole code: Sub collection() Dim COL1 As New collection Dim REPL As Variant Dim FRST As Variant Dim SCND As Single Range("c2:F2").Select For Each cell In Selection COL1.Add (cell.Value) Next cell For I = 1 To 4 If Len(COL1.Item(I)) < 4 Then Do Until Len(REPL) = 4 COL1.Item(I) = 0 & Item.COL1(I) Loop End If Next FRST = COL1(1) & COL1(2) & COL1(3) & COL1(4) SCND = Len(FRST) MsgBox (SCND) MsgBox (FRST) End Sub can you process items in a collection idividuall -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Processing Time | Excel Worksheet Functions | |||
excel processing | Excel Worksheet Functions | |||
Processing Data | Excel Worksheet Functions | |||
data processing | Excel Discussion (Misc queries) | |||
Conditional Processing | Excel Discussion (Misc queries) |