Hi ,

I have values in 4 Cols a,b,c,d and row count varies... For ex i make selection from A1 to D5

I want values of colA1 to A5 stored Range K1
values of colb1 to b5 stored in range K2
values of colC1 to C5 stored in range K3 and
values of colD1 to D5 stored in range K4..

I need the values of each columns seperately based on the selection....Any suggestions...