Sabotage
Board Regular
- Joined
- Sep 19, 2013
- Messages
- 58
Dear all,
Yesterday I have updated Office-365 one of our company tablets (running the latest Windows 10 OS). In one of my data collecting excel workbooks I use userforms to gather data from users. The following line was working just fine before the update, but now I get a:
Run-time error '1004'
AutoFilter method of Range class failed
Here is the line which gives me the headache:
(RD is worksheet, cb_DatePicker is a date to be filter by)
I have a virtual machine on the same PC with Office 2016 install and the code works as just fine. Any thoughts?
Thanks in advance...
Yesterday I have updated Office-365 one of our company tablets (running the latest Windows 10 OS). In one of my data collecting excel workbooks I use userforms to gather data from users. The following line was working just fine before the update, but now I get a:
Run-time error '1004'
AutoFilter method of Range class failed
Here is the line which gives me the headache:
(RD is worksheet, cb_DatePicker is a date to be filter by)
VBA Code:
With RD
.Range("A2:F2").AutoFilter Field:=2, Operator:= _
xlFilterValues, Criteria2:=Array(2, Format(cb_DatePicker, "mm/dd/yyyy"))[/COLOR]
'rest of the code here
End With
I have a virtual machine on the same PC with Office 2016 install and the code works as just fine. Any thoughts?
Thanks in advance...