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