I'm very new to VBA and i would like to know if its possible to delete rows that has a specific serial number in column A. I am going to use the macro in different workbooks (not at the same time). I have tried the one below but it finds a serial number that starts with 140 (1407) and then nothing happens.
Please Login or Register to view this content.
What i want is to delete the rows if it shows a value of 140, 1708, 2071, 759 and 1313.
Thanks in advance
Better is to start to read the VBA help of Find method, all you must know in …
try this code
hope this will workPlease Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Thank you so much, will this work if the i have 51 columns (AY)?
Yes it will work , but it will filter that value only from column A ok
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks