LinkBack URL
About LinkBacks
I'd like to delete all rows where there's a specified value in a specified column. For example:
-delete all rows where there's an "x" in columnF
-if cells F15,F17 and F22 have an "x"
The function will delete rows 15, 17 and 22.
Thanks!
I'd like to delete all rows where there's a specified value in a specified column. For example:
-delete all rows where there's an "x" in columnF
-if cells F15,F17 and F22 have an "x"
The function will delete rows 15, 17 and 22.
Thanks!
Last edited by mcmuney; 06-13-2011 at 06:13 PM.
Does column F would have cells that will contain only an "x" or or cells with other text strings that contain "x"? If it is the former, you can use AutoFilter if you're dealing with a table. Filter out as needed and then select the range (from the row indicator), right-click and select Delete.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Column F may have other values, but I need to only delete where the value is only "x". Also, I need a macro that will do this. Thanks.
Try...
Please Login or Register to view this content.
HTH
Regards, Jeff
I get a run-time error '1004'.
Can you post a small sample workbook?
On the attached sample, when the macro is run, rows 8 and 10 should be deleted (because of the "x" on column F).
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks