ExcelBanter - View Single Post - Delete Rows based on # of rows (no variable?)

DMoney

DanaK - Feel free to email me at and attach your file
and I will see if I can better understand what you are trying to accomplish.
I am sure that we can get it done.

regards,
dmoney

"DanaK" wrote:

I typed done to end the sheet & that stopped it from running to the bottom,
but it doesn't delete any rows. It just drops down to the cell with done. Is
there something else I'm not doing?
DanaK

"dmoney" wrote:

I set the loop to end when the activecell is equal to "done" -- you can
either type the word done in column A at the bottom of your spreadsheet or
change the word done in the do statement to something that works for u.

"DanaK" wrote:

SO frustrated. I'm a very light-weight VBA user. I have a document where I
need to delete several rows at a time, shifting up. Always three rows. I
tried recording this, but it doesn't work that way. I've dug around in Help
until I'm utterly confused as to where to start. I have a workbook with the
steps (what I was given to follow) but I only really need to know about
deleting rows. I think I might be able to figure out the rest. I'll need to
run this same sequence of steps multiple times, but I can figure that out as
well. Thanks to anyone who can help!--
DanaK