plss help...

[ganesh_05]

hii frnds,

I am a facing a problem with data handling in worksheets. I have some data like this...

In column A1, i have different variables like p1,p1,p1,p1,p1,p1,p2,p2,p2,p3,p3,p3,p4,p4,etc.

and the data related to p1(in cell A1) is from B1 to Z1, p1(cell A2) is from B2 to Z2, p1(cell A3) is from B3 to Z3 etc.

so i want to show all the data related to P1 (in all the rows) in a listbox using rowsource property. And the same i want to do it for p2, p3 etc.

how to do this??

Thanks in advance...

Ganesh.

 

[jindon]

Is array Data picking up the values you wanted?

I can not even imagine how incorrectly displayed.

 

[ganesh_05]

Hi jindon,

Thanks for the reply.

foundout the mistake... actually when i m setting r value... i m using .cells instead of .columns(1)...

so everytime it is picking the same value and showing the same data.... becoz both columns 1 and 2 contains the same set of variables p1,p2,p3... but i need to pick the value from column 1 for 'r'...

now its fine... thanks anyway...

cheers!
Ganesh.