Check whether text in a cell contains a string

C

Colin Macleod

I want to copy selected rows from a database on one worksheet to another
worksheet. The criteria will be whether the text in column C (for example)
contains a string that is input by the user. So if cell c5 contains "Europe"
and the user has input "rope" (into a text box on a user form) then the
entire record on row 5 would be copied.

I know this can be done via AutoFilter then Custom then Contains - but this
is part of a VBA project so I need some VBA code to do this.

All help gratefully appreciated.

Colin Macleod
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check whether text in cell contains "?" 2
check if a cell contains a number, not text 2
Excel If a Cell Contains a Certain Text (From Another Table) 0
Last Modified By in a cell by user 3
UDF that checks if a cell contains a period. 3
Fade text in a cell, disappeared when we input new text. 1
Find next cell that contains 11
VBA: How can I use a string variable as autofilter criteria? 4

Top