This partially did what I needed. I have to click the button
mulitpul
times to delete the values, and it is only taking out the one cell, i
really need it to clear the whole row across and do them all at once
to
eliminate confusion. all while keeping the spacing of the sheet
exactly
the same and without the button moving towards the center of my
document.

Hope this helps

Ah.., yes indeed! Sorry about that! Change...

.Rows(n).Delete

...to

.Cells(n).EntireRow.Delete

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion