Dear Users,
can anyone please help me why my code doesnt work?
(please also find the file attached)
Please Login or Register to view this content.
thank you indeed for your kind help!
br
Peter
Dear Users,
can anyone please help me why my code doesnt work?
(please also find the file attached)
Please Login or Register to view this content.
thank you indeed for your kind help!
br
Peter
Please explain what "doesn't work" means.
- Does the code run?
- Does it run but do nothing?
- Does it produce error messages? If so, what do the messages say?
- Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
- Does it hang?
Please Login or Register to view this content.
...thank you jindon... what a silly mistake
one more question please.. my initial goal was to delete the row where the two conditions are met.. I wrote it like below but doesnt work..do you know why?
Please Login or Register to view this content.
When you delete/add row(s)/column(s), better loop backwards like
For each deletes one row when consecutive rows/columns are to be deleted.Please Login or Register to view this content.
Another would be Union method and delete all at the end, AutoFilter etc...
very cool! thank you again jindon!
Try this
Please Login or Register to view this content.
peterschein,
You should be careful that your code is based on the named range, so if the range in the named range changes, yours and mine don't need to change, but the other one should.
Please don't quote entire posts unnecessarily. They are just clutter and make threads hard to read.
Use the "Quick reply" instead
Thanks
If your named range refers to, say C10:D100, my code doesn't need to be changed.
That's what I'm saying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks