View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
theo theo is offline
external usenet poster
 
Posts: 66
Default Macro Help - ASAP - Please!

I have this macro which works great.
But I need to ALSO copy/paste the format of the cells

Sub Macro1()
Sheets("Sheet1").Rows("1:1").Copy
Sheets("Sheet2").Rows("3:5").PasteSpecial
Paste:=xlPasteValidation, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub