| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Wildcard Code
I have the following could that checks a column in a master file to select
records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
If Left(wsMaster.Range("ag" & iRow + 0),1) = "c" Then
-- Gary''s Student - gsnu200853 "Tony" wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
Try instr
If InStr(Sheets(wsMaster).Range("ag" & irow + 0), "c") = 1 Then Mike "Tony" wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
I just noticed you may want it to ignore case
If InStr(1, Sheets(wsMaster).Range("ag" & irow + 0), "c", 1) = 1 Then Mike "Mike H" wrote: Try instr If InStr(Sheets(wsMaster).Range("ag" & irow + 0), "c") = 1 Then Mike "Tony" wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
Gary, even though I checked the running of the code and verified that the
cell contents does contain a Cxx value after reading each record, it bypasses the record and moves on the to the next record with the final outcome being no records written. Any suggestions? Tony "Gary''s Student" wrote: If Left(wsMaster.Range("ag" & iRow + 0),1) = "c" Then -- Gary''s Student - gsnu200853 "Tony" wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
Mike, when I use your code, I get a Run-time error '13' - Type mismatch error.
"Mike H" wrote: I just noticed you may want it to ignore case If InStr(1, Sheets(wsMaster).Range("ag" & irow + 0), "c", 1) = 1 Then Mike "Mike H" wrote: Try instr If InStr(Sheets(wsMaster).Range("ag" & irow + 0), "c") = 1 Then Mike "Tony" wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
One more using a wildcard:
if lcase(wsmaster.range("ag" & irow).value) like lcase("c*") then Tony wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
Try both "c" and "C"
-- Gary''s Student - gsnu200853 "Tony" wrote: Gary, even though I checked the running of the code and verified that the cell contents does contain a Cxx value after reading each record, it bypasses the record and moves on the to the next record with the final outcome being no records written. Any suggestions? Tony "Gary''s Student" wrote: If Left(wsMaster.Range("ag" & iRow + 0),1) = "c" Then -- Gary''s Student - gsnu200853 "Tony" wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA Wildcard Code
Thanks again Dave, that did the trick.
"Dave Peterson" wrote: One more using a wildcard: if lcase(wsmaster.range("ag" & irow).value) like lcase("c*") then Tony wrote: I have the following could that checks a column in a master file to select records that have the following c* (i.e. c01, c02, etc..). However due to some error in the way I am writing the code, I cannot get it to produce records. If wsMaster.Range("ag" & iRow + 0) = "c* " Then How do I code it the slect any records that start with "C" and then use the wildcard character "*"? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the wildcard with IF | New Users to Excel | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| If and wildcard | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| sum if wildcard | New Users to Excel | |||
Linear Mode
