hiden cells copied automatically to another workbook, can I stop .

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have selected data from a workbook that is automatically updated to another
workbook. It also copies the hiden cells, can I stop the hidden cells from
automatically be copied?
 
Sub CopyVisible()
Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Copy
'YOU WILL HAVE PROBLEMS WHEN PASTING
End Sub
 
Back
Top