Hi,
I current have VBA coding in my worksheet, however I need to future proof for 2015.
I haven't created my 2015 code yet, but my 2014 code is:
Sub Macro1()
'
' Macro1 Macro
'
'
Range("D2").Select
Selection.Copy
Workbooks.Open Filename:= _
"G:\<FileName>.xlsm"
Range("D2").Select
ActiveSheet.Paste
Range("D3").Select
Application.Goto Reference:="R5C1:R250000C34"
Selection.Copy
Windows("Contract Review - Master Doc.xlsm").Activate
Range("A5").Select
ActiveSheet.Paste
Cells.Select
Cells.EntireColumn.AutoFit
Range("A1").Select
Columns("B:B").ColumnWidth = 10.29
Columns("C:C").ColumnWidth = 9
Columns("D:D").ColumnWidth = 5.57
Columns("C:C").ColumnWidth = 17.43
Columns("B:B").ColumnWidth = 14.86
Columns("C:C").ColumnWidth = 13.43
Columns("D:D").ColumnWidth = 10.14
Windows("Contract Extraction.xlsm").Activate
ActiveWindow.Close
End Sub
I need a variable that says, if it's 2014, then use this code.
However, if it's 2015, then use the 2015 code.
Any help appreciated.
Many thanks.
Bookmarks