Asif, the only thing I can think of is to copy the entire column to another
column on the same sheet or a different sheet. Then, after manipulating the
column, you could restore the original formatting by copying the new column
and paste special over the original column, pasting formats only. You
should be able to record doing this so you can see how to do it. Same with
the row. James

"Asif" wrote in message
...
Is it possible to save and restore the formats of entire row and column.
Basically I want to write a SelectionChange event which would highlight
the
current row and column. I'd much appreciate if somebody could help me with
the code.

--
Thanx & regards,
Asif