Yes very simple!
One silly question. When the rows deleted it shifted everything up so here is what I did. I changed it to .ClearContents however i have some tables below I need the cells merged, however that command will not work with the cells being merged below my specified looped range. Any ideas how i can get around this? I'm so very very close, however i cannot figure out that peice.
I may just turn the area i need into a text box if there is no other way.
Again, thank you for your help. You have been fantastic!
-- Chris
Quote:
Originally Posted by GS[_2_]
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 |