im using the code below to find the text 'Filming' in a column i specify then delete that row, however, it is case sensitive, i.e. it will not delete the row if comes accross 'filming'.
i assumed that using the wildcards * that it would know what to do, but it doesnt.
any ideas how to fix this?
Please Login or Register to view this content.
Please Login or Register to view this content.
Gary's Student
Try this instead of like
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
that doesnt work. thats the same as
it wont see 'Filming'. most entries are 'Filming', a few are 'filming'.Please Login or Register to view this content.
that doesnt work. thats the same asOriginally Posted by Jakobshavn
Please Login or Register to view this content.
it wont see 'Filming'. most entries are 'Filming', a few are 'filming'.Please Login or Register to view this content.
That works, cheers Mike!!
Can you explain how it works?
i know the syntax for the INSTR function is:
InStr( [start], string, substring, [compare] )
is it the case that vbTextCompare 'is-not' case sensitive?
how does the > 0 part work?
Last edited by intothewild; 11-25-2012 at 02:36 PM.
@intothewind
Heres a link explaning the Instr function http://www.aivosto.com/vbtips/instr.html
Jakes solution will work. Did you try it? Here's a couple of examples.
Please Login or Register to view this content.
Thanks Mike the link is really good. I did try Jakes but it didnt work for me, i'll try again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks