View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gmunro gmunro is offline
external usenet poster
 
Posts: 34
Default Macro to create format painter

This worked for me.

Range("D6").Select
Selection.Copy
Range("D8").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False