Register
Log In
Unanswered
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.
Dashboards
June 25, 2016
Offline
Hi David
Any reason why you would want to "store" the CF applied using VBA?
Sunny
Dashboards
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?Â
Dashboards
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
Most Users Ever Online: 57
Currently Online:
13 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Mohamed Rehan Memon
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
