PDA

View Full Version : Ask for values and delete row



ermis1975
08-03-2008, 10:55 PM
I want to be asked for some values and delete all rows that contains this values. It will be found in one column.
Thanks.

xld
08-04-2008, 12:55 AM
Asked in many questions, or all in one question?

Why not just filter the column, and then delet the visible rows?

ermis1975
08-04-2008, 01:54 AM
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

xld
08-04-2008, 02:01 AM
Isn't that exactly what autofilter will allow you to do?

ermis1975
08-04-2008, 03:08 AM
yes but I want to do it with VBA. Pop up window with values I want to delete rows etc.