i have a macro in excel and on the second page i want to have the rows
perform like a table by pulling down and wrapping, but i can't do it and i've
searched all formats possible. on a new worksheet, it will but not on this
one.

can you please help.

thanks

pj