Hello,
VBA Question,
Just trying to figure out how to copy only the "Visible" cells from one sheet, and paste it to another, without the "Formatting"
Here's what I've tried, and keep getting error 400:
Attempt#1
Worksheets("Sheet1").Range("A12:E153").SpecialCells(xlCellTypeVisible).Copy
Worksheets("Sheet2").Range("B2").PasteSpecial _
Paste:=xlPasteValues, _
Operation:=xlPasteSpecialOperationNone, _
SkipBlanks:=True, _
Transpose:=False
Worksheets("Sheet2").Columns("B:F").AutoFit
Attempt#2
Dim rang As Range
Set rang = Sheets("Sheet1").Range("A12:D" & "A153").SpecialCells(xlCellTypeVisible, xlPasteValues)
rang.Copy Sheets("Sheet2").Range("B3")
There's probably even a simpler way of doing this,
Any help would be appreciated,
Thanks,
Bookmarks