|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2009, 02:55 PM
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
May 15th, 2009, 03:01 PM
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
May 15th, 2009, 03:04 PM
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
May 15th, 2009, 03:06 PM
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
May 15th, 2009, 03:15 PM
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
May 15th, 2009, 03:17 PM
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
May 15th, 2009, 03:18 PM
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
May 15th, 2009, 03:21 PM
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
May 15th, 2009, 03:34 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
