Sounds like something you could easily test out yourself Don. Let us know
what you find out, please.

Regards,
Tom Ogilvy

Donald Lloyd wrote in message
...
Hi,

It just ocurred to me.

Example:-
In a worksheet, the top 2000 rows by 50 columns are used to hold data that
is being manipulated.
The cells in this range are all carefully formatted. All rows below this
range are hidden and have not been formatted, as I, maybe wrongly, think
that this can increase the Used Range and result in undue overheads.

Query:-
If cell contents are deleted using Shift(XlUp), does this mean that the
2000
rows will lose their formatting from the bottom up ? If yes, what is the
best solution.
In the same vein, but more academic, if entire columns are formatted, will
the formatting be gradually eroded from the bottom up if cells are shifted
up or rows deleted ?

regards,
Don
--