Hi guys,
I have a problem with the following code in VBA. I'm very new to VBA, so I can't see what seems to be the problem.... The followin code gives me Run-time error 1004 autofilter method of range class failed....
Sub SplitData()
Dim ark As Worksheet
Dim arkNew As Worksheet
Dim Data As...