In my search I am not sure how long the list will go. Can you please help me with such a circumstance to modify the code?
Please Login or Register to view this content.
In my search I am not sure how long the list will go. Can you please help me with such a circumstance to modify the code?
Please Login or Register to view this content.
Hi,
Could you expalin exactly what you want help with as it is not clear?
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
If I am reading it correctly try the code below on a copy of your data
Please Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Yes it's the problem WasWodge. You understood it well.
The above code only deletes the first row (which I want to keep and delete the rest others) but rest others remains same as it is.
Thanks in advance.
Also the next targeted row becomes 50 which I want to delete. and so on as the rows will slip.
I am a bit puzzled here. On my data it deletes rowsThe above code only deletes the first row
1
51
101
151
201
251
301
351
401
451
501
et cetera
Your original post deletes the first rowThe above code only deletes the first row (which I want to keep and delete the rest others)
Run the code below. What lines have an "a" in column A and which rows do you want to delete (list the first 5 rows to delete from the original data)?Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by WasWodge; 03-10-2013 at 05:32 PM.
Rows with a: 1, 51, 101, 151, 201, 251 and so on.
I need to delete rows: 52, 103, 154, 205, 256
Rows with a: 1, 51, 101, 151, 201, 251 and so on.
I need to delete rows: 52, 103, 154, 205, 256 and so on.
Deleted rushed editing
Last edited by WasWodge; 03-10-2013 at 05:47 PM.
See last post as your last post has registered but not mine
The code did not ran.
My fault
Please Login or Register to view this content.
Worked. Thanks a lot.
Happy we got there. Remember to mark the thread as solved if you feel your question has been answered.
I am really happy too. Marked solved. It wont be possible with out your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks