zoom38
06-24-2006, 05:48 AM
I have a sub that locates data(a name) in column A and then deletes the entire row. My problem if I have four names/rows to delete, it will only delete two of them. I believe it is due to the way Im doing it. I count the total # of rows, use that as my range and then when my routine finds a name to delete it will delete the row, effecting my range but Im not sure what is happening. I'm attaching my file. The problem is in module 7. If you look in module 7 Im copying the names from the first worksheet ("Totals") and pasting to the last worksheet ("Monthly Tally"). It probably would be easier to not paste the the ones I don't want (Promoted and Transferred) but I couldn't figure out how to do it so I went the way you see it in module 7. Im sure it is an easy solution for the experienced Excel users but not so easy for rookies like myself.
Please take a look.
Thanks
Gary
Please take a look.
Thanks
Gary