I am trying to delete rows that contain text with a special character in column O. The text I am searching for contains PO# and will look something like this PO#B7605887-1, so I need it to be PO#* so it catches the text if it contains anything after the special character.
The code I created below is not working. What am I doing wrong?
Please Login or Register to view this content.
try this change
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Do any values contain the letters "PO" without containing the symbol #?
maybePlease Login or Register to view this content.
Last edited by Solus Rankin; 02-24-2014 at 02:31 PM.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Another:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 02-24-2014 at 03:42 PM.
Solus, if I add the * after "PO", then it would delete also delete rows with words that start with a PO, like possible or potential, etc. I need it to delete rows with the phrase "PO#".
Hi, John,
your code
isnīt qualfied for Sheets("Call Data") but should refer to the ActiveSheet instead.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Originally Posted by HaHoBe
Hi, John,
your code
isnīt qualfied for Sheets("Call Data") but should refer to the ActiveSheet instead.Please Login or Register to view this content.
Ciao,
Holger
"Call Data" is the activesheet? Isn't it?
Hi, John,
I donīt know to be honest. But if I see a code like
Iīd go the way to usePlease Login or Register to view this content.
to avoid any possible other activesheet orPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
@ HaHoBe - I agree with you completely. But what I gathered from the sub in Post#1 was two possibly unnecessary With Statements. No mention of other workbook objects or range objects or sheet objects. Perhaps I'm wrong as well.
I use the same code to delete rows with other text strings, the problem I'm having is that it is not deleting any rows that contain "#". I'm looking for code that helps me handle that issue.
Did you test all the suggestions?
Sorry. This should fix that problem:Please Login or Register to view this content.
Try this...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks