Please Login or Register to view this content.is not working for me.. but if I removePlease Login or Register to view this content.thenPlease Login or Register to view this content.works fine.. So confused by what is probably a simple fix I'm just not seeingPlease Login or Register to view this content.Any help is appreciated!
How is it not working?
What error message, if any, do you get if you remove On Error Resume Next?
If posting code please use code tags, see here.
I don't get any error message.. the rows just do not get deleted
Any chance you could upload a sample workbook?
Click on GO ADVANCED, scroll down and click Manage Attachments.
This is a copy of my file.. It is not nearly complete yet, and I am basically trying to sort thru data based on what is in the Search Textbox. Click the "Reports" button on the home page and then make sure the Checkbox beside "All" is checked. Then type "Guard" into the Search Textbox and click Generate. The code I am working on is located in the "Generate" command button module
Here is a screenshot. http://prntscr.com/fcfp6b
Put a ' in front of theline in the code shown in the screenshot and you will see how it sorts the data with font color.. it just does not delete itPlease Login or Register to view this content.
Last edited by unit285; 05-26-2017 at 01:26 PM.
Why do you have Not here?
Surely you want to delete the row if InStr(iCell, UCase(Search)) > 0, ie the search value is found in the cell.Please Login or Register to view this content.
Try dropping the Not, when I did rows were getting deleted.
By the way, whenever you delete you should loop from the top to the bottom.
If the Search Term is located, I want to delete any rows that do NOT include the search term.
I'm not sure what you mean by looping from top to bottom.. Sorry I am not much of a vba expert.. I just meddle with it enough to get myself into trouble like this
The goal for the ufReport Userform is to search for criteria, so if there is a search term I want to located rows with that search term, if there is a MFR selected, then only show that MFR, price levels the same way.. basically it narrows down the data to just the rows I want to see
Why not test for =0?
Please Login or Register to view this content.
Yeah I could do that.. But that does not solve my main problem. I will come back thru the code later looking for ways to optimize it.. For now I would like to know why the lineis not workingPlease Login or Register to view this content.
It's nothing to do with optimizing the code, did you try what I suggested?
As for why that line isn't deleting anything, are you sure it isn't? Have you checked if it's actually being executed?
I did try it. It made zero difference. Let me explain as simply as I can with these screenshots for reference.
Step 1
I enter "Guard" as a search term. My code looks like this: http://prntscr.com/fcgkga
What should happen is any rows of data that do not include "Guard" should turn Red.
Here are the results: http://prntscr.com/fcgl45
Step 1 Results in a Success.
Step 2
I enter "Guard" as a search term. My code looks like this: http://prntscr.com/fcgkr4
What should happen is any rows of data that do not include "Guard" should get deleted.
Here are the results: http://prntscr.com/fcglm5
Step 2 Results in a Failure.
The only difference in the code between Step 1 and Step 2 are these, in Step 1 I usedAnd in Step 2 I usedPlease Login or Register to view this content.Please Login or Register to view this content.
Which worksheet should the rows be deleted from?
Is it 'Database' or the hidden worksheet 'Report285'?
Database should not get altered. Delete from Report285
The more I look at this code the more confounded I become. Why does EntireRow.Font.Color work and EntireRow.Delete not? It makes no sense. Wtf am I missing
Perhaps it's an idea to look at the rest of the code rather than concentrating on that specific line/section of code - there certainly seems to a few other things going on.
What exactly, from start to finish, is the code meant to do?
The Database sheet contains data imported from my point of sale, specifically it lists power units my store has in stock. The Reports userform is designed to sort thru the database and find specific units based on the criteria entered. So the search textbox should allow me to search for a string in the description of each power unit. Maybe i want to search for Log splitters, or pressure washers, etc... the Reports285 sheet works as a buffer so data from the database never gets deleted. It's kind of a work in progress too.. so it may yet evolve into other functionalities etc...Originally Posted by Norie
I am quite convinced that my code is structured as i want it. I tried a few other lines in place of [such asPlease Login or Register to view this content.and it seems like they all work fine except for the delete linePlease 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