Here is a piece of code i was given that will copy an entire row but not the hidden columns. What changes would I need to make to make it copy the hidden columns as well. Thanks.
Dim rngContent As Range
Dim intLr As Integer
Dim intLc As Integer
intLr = .Cells(1048576, 1).End(xlUp).Row
intLc = .Cells(3, 16384).End(xlToLeft).Column
Set rngContent = .Range(.Cells(3, 1), .Cells(intLr, intLc))
rngContent.SpecialCells(xlCellTypeVisible).Copy
With Worksheets("BuildList")
With .Cells(3, .Cells(1, 16384).End(xlToLeft).Column + 0)
.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End With
Bookmarks