deleting specific rows or columns
I have some code built to delete specific rows of data. It starts at the bottom of the document and moves up. It will do the first delete fine but then errors on the next line. Am i missing something between each delete command?
Please Login or Register to view this content.
Last edited by Mick S; 04-20-2011 at 10:27 PM.
Hello Mick S,
What error number do you get?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Once you delete row 173:500, a new set of rows becomes rows 173:500...so how does it get out of that senerio?
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
@ Leith Ross
The error code i get is
Run Time error '1004':
Method 'Range of object'_worksheet failed
@jwright650
I thought about that and that is why i started at the bottom and moved my way up. That way the row numbers that are being deleted are always the same.
Mick S,
Change "range" to "rows" and start from the last row:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks