Hi All
I am using the below code to extract non filtered lines to another to another sheet later on. It was working fine, but as I keep modifiying it, I'm now getting funny results?
Does anyone have any idea what I have done
Thanks
I am using the below code to extract non filtered lines to another to another sheet later on. It was working fine, but as I keep modifiying it, I'm now getting funny results?
Does anyone have any idea what I have done
Code:
Sheets("Sheet1").Range("B23:D37").ClearContents
Sheets("Sheet1").Range("B23:D37").Value = Sheets("Sheet1").Range("B4:D18").SpecialCells(xlCellTypeVisible).Value
Thanks