Log In
Register
Home
December 5, 2016
Offline
BTW, just side track question is that a way we can store Conditional Formatting using Macro/VB script.
Pls refer attached, kindly advise the possibility, to create a Macro to store the Conditional format we have applied in a worksheet.
VIP
Trusted Members
June 25, 2016
Offline
Hi David
Any reason why you would want to "store" the CF applied using VBA?
Sunny
VIP
Trusted Members
June 25, 2016
Offline
Hi David
See if this is what you wanted.
Please note that the range, conditions, colors etc. have to be hard-coded. You will need to modify the codes to suit your needs.
Hope this helps.
Sunny
December 5, 2016
Offline
Thansk Sunny the code that's exactly what I want , I will modify the code for application.
December 5, 2016
Offline
Can we set a Macro to filter Data base on "Date" criteria
For example in the sample file we want to filter in N column [ Vendor reply]
Today' s record and date before yesterday's record?
VIP
Trusted Members
June 25, 2016
Offline
Hi David
You did not mention which column is the date to filter. I am assuming it to be column W so change it to suit your needs.
Sub FilterByDate()
Dim ColumnNo As Long
'Change to which column with date to filter
ColumnNo = 23 '(this is column W)
Range("A1").AutoFilter
Range("A1").AutoFilter Field:=ColumnNo, Criteria1:=">=" & CLng(Date - 1), Operator:=xlAnd, Criteria2:="<=" & CLng(Date)
End Sub
Sunny
1 Guest(s)
