xl sheet table column and row header

[GokulGKM]

hi,

        how to add XL column header in this example....but all ready added name is  not column header this is Row 1 fileds.i want exact column header filed how to  add.because my date goes more than one xl sheet the column header not display the other xl sheet..

[GokulGKM]

hi,

        how to select column range.for example

     Row 1------------------->A 1:Z1

     ROW 2------------------>A2:Z2

     COLUMN1------------>a:a

     column header-------->???????????

in this way how can i select column header in XL using ActiveX property.