I will never, ever get this correct ...
 

Range("A" & new_start & " :D" & new_rows).Select

That last bit-- & ") was a problem, but so was the space after the ":D "

I would drop both spaces:
Range("A" & new_start & ":D" & new_rows).Select



Larry Levinson wrote:

Range("A" & new_start & " :D " & new_rows & ").Select

ok, where are the `"' and `&' in the wrong places? I promise to try to
get it correct from now on. sigh ....

Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)

--

Dave Peterson