Related:
- Wildcards or values in a macro?
- Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
- Macro to copy and paste values ✓ - Forum - Excel
- How to compare two cell values in excel using macro ✓ - Forum - Excel
- Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
- Run macro when cell changes to specific value - How-To - Excel
2 replies
TrowaD
- Posts
- 2691
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 14, 2021
Hi Sworcester,
Use "Like" instead of "=" when using "*" as in:
If range("A1").value like "*Super*" then
or
If left(range("A1").value,5) = "Super" then
will work as well.
Best regards,
Trowa
Use "Like" instead of "=" when using "*" as in:
If range("A1").value like "*Super*" then
or
If left(range("A1").value,5) = "Super" then
will work as well.
Best regards,
Trowa
sworcester
- Posts
- 3
- Registration date
- Tuesday November 22, 2016
- Status
- Member
- Last seen
- November 22, 2016
Here is kinda what gets spit out
Sub SMC_Sys()
'
' SMC_Sys Macro
'
'
ActiveSheet.Range("$A$1:$CH$52073").AutoFilter Field:=14, Criteria1:=Array( _
"Vendor 1", "vendor 2", "another", "yet another", _
etc etc etc... ), Operator:= _
xlFilterValues
End Sub
I am trying to not have to alter much or write much, instead using the RECORD function to d most of the work. The idea is to create a macro that is portable for every month so the RANGE may change each month as well
Sub SMC_Sys()
'
' SMC_Sys Macro
'
'
ActiveSheet.Range("$A$1:$CH$52073").AutoFilter Field:=14, Criteria1:=Array( _
"Vendor 1", "vendor 2", "another", "yet another", _
etc etc etc... ), Operator:= _
xlFilterValues
End Sub
I am trying to not have to alter much or write much, instead using the RECORD function to d most of the work. The idea is to create a macro that is portable for every month so the RANGE may change each month as well
Subscribe To Our Newsletter!
