Hi, Dan Elek

Thank you for your help in my last question...
Single Under Line
CELLS(??).Borders(9).LineStyle = 1

and i have another question:-
how can i put the background color in it ( and the code of COLOR TABLE) ?