Thread: hiden cells copied automatically to another workbook, can I stop .
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default hiden cells copied automatically to another workbook, can I stop .
Sub CopyVisible()
Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).C opy
'YOU WILL HAVE PROBLEMS WHEN PASTING
End Sub



--
Regards
Dave Hawley
www.ozgrid.com
"Fred" wrote in message
...
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?

Reply With QuoteReply With Quote