I have written code to retain all the data containing c:\downloan in Col A and to delete the items not containing this, but cannot get it to work
It would be appreciated if someone could kindly amend my code
Please Login or Register to view this content.
Autofilter considers the top row a header and Row 1 wont be filtered regardless of what is in it.
The .CurrentRegion method used in your code above doesn't select beyond the empty row 6 in your example data. The .End(xlUp) method below filters all the data in column A.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for your input and code
It works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks