C chipsy Joined Feb 20, 2007 Messages 5 Reaction score 0 Aug 28, 2009 #1 hi how do i copy a range of a sheet to the same range of another sheet AS IS (with formatting and row/column dimensions) using vba? thanks
hi how do i copy a range of a sheet to the same range of another sheet AS IS (with formatting and row/column dimensions) using vba? thanks
C chipsy Joined Feb 20, 2007 Messages 5 Reaction score 0 Aug 28, 2009 #2 i've resolved it by: Code: Worksheets("SheetX").Cells.Copy With Worksheets("SheetY") .Cells.PasteSpecial xlValues .Cells.PasteSpecial xlFormats End With
i've resolved it by: Code: Worksheets("SheetX").Cells.Copy With Worksheets("SheetY") .Cells.PasteSpecial xlValues .Cells.PasteSpecial xlFormats End With
