Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array
the statement below takes the data in table 1 col A starting at A4 "03 DEC
50.000 (RIM TY)" and divides string into cols if a space is found. a=3, b=DEC, c=50, d=(RIM, e=TY). the problem is it will ignore dividing col A in the 2nd table that is below first table. how would i modify the statement to work on data string in 2nd table starting 7 lines below end of the date data string in first table. the tables are divided by : col A 03 DEC 50.000 (RIM TY) 'data end table 1 TOTAL Last Price 37.54 Put Series/ Strike Price 03 AUG 25.000 (RIM HC) 'data start table2 03 AUG 27.500 (RIM VX) 'break A into seperate cols Range(Range("A4"), Range("A4").End(xlDown)).TextToColumns Destination:=Range("A4"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _ :=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)) i am using excel 2k thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) |