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.
Bob Phillips
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
Bob Phillips
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.