Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading values from multi-area selection
I have this situation where user picks selected columns in the table ... when
I am trying to read the values its giving me only first selected area values. I need to read the values row wise, is there anyway that I can read each row into an array? For example: Table A B C D 1 2 3 4 3 6 8 9 user selects columns A and C .. in this case when I read second row values I shud get an array with 1, 3 values Similar thing is required for columns, like user selects row1, row2 and when I read the column values I should get array with values A, 1. There can many multiple-area selections. Just wondering is there any simple to figure this out. I am doing this in C#. Any help or suggestions would be appreaciated. thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading values from multi-area selection
Loop thru the Selection areas... '-- For Each rArea in Selection.Areas For Each rCell in rArea 'add rcell value to the array Next Next -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "guest" wrote in message I have this situation where user picks selected columns in the table ... when I am trying to read the values its giving me only first selected area values. I need to read the values row wise, is there anyway that I can read each row into an array? For example: Table A B C D 1 2 3 4 3 6 8 9 user selects columns A and C .. in this case when I read second row values I shud get an array with 1, 3 values Similar thing is required for columns, like user selects row1, row2 and when I read the column values I should get array with values A, 1. There can many multiple-area selections. Just wondering is there any simple to figure this out. I am doing this in C#. Any help or suggestions would be appreaciated. thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi area Array using IRR function | Excel Worksheet Functions | |||
Use values instead of labels on X-axis in Area/Stacked Area Charts | Charts and Charting in Excel | |||
Multi-colour 'Area' chart | Excel Discussion (Misc queries) | |||
Multi-colour Area chart (see attachment) | Charts and Charting in Excel | |||
Extract values from a multi-select multi-column list-box | Excel Programming |