View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Copying worksheets with formulas in hidden columns

I have a "Master" worksheet with hidden columns and rows. When I copy the
Master, the formulas in the hidden columns are are not copied (which are
required). Currently I have to unhide all rows and columns copy the sheet
then hide everything again on all the new sheets. Anyone know of a workaround?