Hi All,
I have a trouble with the following line of the code:
This works great, it copies data without header but I would also like it to copy 6 colums less.
I have tried
But it gives me Object defining error.
Could you please help me?
I have a trouble with the following line of the code:
Code:
Sheets("Tab2").Select
Rows("5:5").Select
range("K5").Activate
Selection.AutoFilter
ActiveSheet.range("$A$5:$m$5").AutoFilter Field:=11, Criteria1:="<>"
ActiveSheet.UsedRange.Offset(5, 0).SpecialCells _
(xlCellTypeVisible).Copy
This works great, it copies data without header but I would also like it to copy 6 colums less.
I have tried
Code:
ActiveSheet.UsedRange.Offset(5, -6).SpecialCells _
(xlCellTypeVisible).Copy
But it gives me Object defining error.
Could you please help me?
Last edited: