View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Genesis Genesis is offline
external usenet poster
 
Posts: 6
Default macro to save current excel sheet only without losing formatting

I have a macro that saves the current worksheet only (fileformat=xlNormal),
and automatically generates a new filename, but formatting is lost, so
reprinting the sheet looks completely different from the original.