Try recording a macro that does exactly what you want. Come here and post
it if you want help cleaning it up. Give specifics of things you might want
to change including:

Which worksheet do you want to do this on.
Do you want to run it at any group of selected cells?

Things like that.

HTH,
Barb Reinhardt

"Bern Notice" wrote:

Trying to write a macro that highlights a range of cells across 9 columns and
inserts them above a total line. Meaning that the total line needs to shift
down to remain. Any ideas?