Formatting New Worksheet in VB?

• • Reply

  13 years ago

  by Martinelv

  Martin Horton

  , United Kingdom

  Joined 13 years ago

  Does anyone know the code that I need to use to auto-format a new worksheet?  I have a VB macro that copys a worksheet, opens a new worksheet, and pastes the contents.  How do I automatically format the new worksheet so it matches the original?   Cheers.

  Report abuse
• • Reply

  13 years ago

  by ash_pn

  ashutosh

  , India

  Joined 14 years ago

  Hello

  90 % of your work is done. 

  Just try this .It might help.

  While Parting the contents use "PasteSpecial ". For example If you have selected the range which has to be pasted on another worksheet without changing the format  : try

  Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats

  I hope this should solve your problem.

  Ash

  Report abuse
• • Reply

  13 years ago

  by Zorro_ot

  Oliver Tell

  Hamburg, Germany

  Joined 15 years ago

  If I have understood you correctly, you want to copy and paste a complete worksheet. That could easily be achieved by using the worksheet.copy procedure. You just need to declare after or before which worksheet the new worksheet should be inserted.

  If you want to create a new workbook, just dont pass any parameter.

   

  http://msdn2.microsoft.com/en-us/library/microsoft.office.interop.excel._worksheet.copy(VS.90).aspx

  Report abuse