View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
guest guest is offline
external usenet poster
 
Posts: 20
Default 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.