I want to be asked for some values and delete all rows that contains this values. It will be found in one column.
Thanks.
I want to be asked for some values and delete all rows that contains this values. It will be found in one column.
Thanks.
Asked in many questions, or all in one question?
Why not just filter the column, and then delet the visible rows?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Because every time the value may be different. So I have to clear rows with specified values. Eg..set value to delete...A, set another value? Y or No... and proceed
Isn't that exactly what autofilter will allow you to do?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
yes but I want to do it with VBA. Pop up window with values I want to delete rows etc.