Hey guys
I am new to macro coding this code was written with 2003 but everytime I try to run these same macros with excel 2007 I get an error messaging about converting the file to a different version. Is there any quick fix for this? Here are the macros
'
Selection.Copy
Sheets("MACRO").Select
Rows("1:1").Select
ActiveSheet.Paste
Range("H1").Select
Application.CutCopyMode = False
Selection.Copy
Range("G16").Select
ActiveSheet.Paste
Range("E1").Select
Application.CutCopyMode = False
Selection.Copy
Range("G17").Select
ActiveSheet.Paste
Range("F1").Select
Application.CutCopyMode = False
Selection.Copy
Range("H17").Select
ActiveSheet.Paste
Range("I1").Select
Application.CutCopyMode = False
Selection.Copy
Range("H18").Select
ActiveSheet.Paste
Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Range("G19").Select
ActiveSheet.Paste
Range("C1").Select
Application.CutCopyMode = False
Selection.Copy
Range("H19").Select
ActiveSheet.Paste
Range("D1").Select
Application.CutCopyMode = False
Selection.Copy
Range("H20").Select
ActiveSheet.Paste
Range("H20").Select
End Sub
Sub PACKLABEL()
'
' PACKLABEL Macro
' Macro recorded 9/7/2001 by Jaynew
'
'
Selection.Copy
Sheets("MACRO").Select
Range("A1").Select
ActiveSheet.Paste
Range("H1").Select
Application.CutCopyMode = False
Selection.Copy
Range("G25").Select
ActiveSheet.Paste
Range("I1").Select
Application.CutCopyMode = False
Selection.Copy
Range("H26").Select
ActiveSheet.Paste
Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Range("G27").Select
ActiveSheet.Paste
Range("C1").Select
Application.CutCopyMode = False
Selection.Copy
Range("H27").Select
ActiveSheet.Paste
Range("G25").Select
End Sub
Bookmarks