-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
field=9
-
B
VBA Autofilter partial match in column
Hi I currently have; Sub Button1_Click() With ActiveSheet.Range("A8:J61") .AutoFilter Field:=2, Criteria1:=ActiveSheet.Range("A5").Value .AutoFilter Field:=4, Criteria1:=ActiveSheet.Range("B5").Value .AutoFilter Field:=9, Criteria1:=ActiveSheet.Range("C5").Value End...- BenGee
- Thread
- .autofilter activesheet.rangea8j61 end field=9
- Replies: 3
- Forum: Excel Questions
-
G
Delay Macro while workbook refreshes from sharepoint
Hello, I have the following macro to pull information from another workbook. When this work book opens it refreshes the data from a sharepoint list. I have tried various attempts to pause the macro to allow the refresh to happen. I have tried various code from the current...- Godders199
- Thread
- activeworkbook.refreshall field=9 refresh set workbook
- Replies: 4
- Forum: Excel Questions
-
Filter Today's Date with VBA -So tricky
Sub Ufa() x = CLng(Date) ActiveSheet.UsedRange.AutoFilter Field:=9, Criteria1:=">=" & x, Operator:=xlAnd, Criteria2:="<" & x + 1 End Sub I have this macro to filter today's date is working great but is not giving me the header only the date without header...I don't know what to do :(...- jevi
- Thread
- clngdate criteria1== criteria2= field=9 operator=xland
- Replies: 5
- Forum: Excel Questions
