I am automating Excel from a VB6 program.
I am writing the Column Headers into Row1
I have managed to color them Grey (Would be nice if I could color the whole line, instead of the 10 Columns I have written Header Names to. But that was not my main question).
My question is -
How can I send the instruction for Row 1 to be 'Fixed' ?
(Is 'Fixed' the correct expression ?, as Googling was not a great success)
The end result should be that Row 1 will remain visible, even when the user goes scrolling down the Rows.

Thanks,
Rob