| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check whether text in a cell contains a string
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check whether text in a cell contains a string
Hi
you could go here http://www.contextures.com/xlautofilter03.html#Copy and adjust that general bit of code to suit. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Colin Macleod" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can Excel check that a text string is even-numbered or not? | Excel Programming | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Macro syntax to check string length in a cell | Excel Discussion (Misc queries) | |||
| check if the text string start with a specific character | New Users to Excel | |||
| check to see if cell contains a string = to member of list | Excel Programming | |||
Hybrid Mode
