![]()
ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q9").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q12").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q17:Q185").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R17:R137").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q16:Q141").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R16:R141").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q16:Q141").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R16:R141").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q17:Q117").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R17:R117").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q16:Q106").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R16:R86").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q16:Q106").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R16:R105").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q16:Q145").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R16:R145").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q6").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q9").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q15:Q313").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R15:R288").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q16:Q141").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R16:R141").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q17:Q117").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R17").Select ActiveSheet.Next.Select ActiveSheet.Previous.Select Range("R17:R92").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select Columns("E:Q").Select Selection.EntireColumn.Hidden = False Columns("J:P").Select Selection.EntireColumn.Hidden = True Columns("H:H").Select With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("Q8").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Range("Q11").Select ActiveCell.FormulaR1C1 = "=RC[-8]" Columns("Z:Z").Select Selection.EntireColumn.Hidden = True Range("Q16:Q145").Select Selection.Replace What:="Y", Replacement:="Z", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("R16:R145").Select Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Sheets("Detail Aust Opers Results").Select Range("AM1").Select ActiveCell.FormulaR1C1 = "30th November 2013" Range("AK1").Select ActiveCell.FormulaR1C1 = "5" Sheets("Consolidated Profit & Loss").Select Range("E35,K35").Select Range("K35").Activate Selection.Replace What:="H", Replacement:="I", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("H28,H17,H11").Select Range("H11").Activate Selection.Replace What:="I", Replacement:="J", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("I11,I17,I28").Select Range("I28").Activate Selection.Replace What:="!U", Replacement:="!V", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("N35:N36").Select Selection.Replace What:="!F", Replacement:="!G", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Range("I60,I66,I77").Select Range("I77").Activate Selection.Replace What:=":U", Replacement:=":V", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Sheets("Australia Summary").Select Range("A1:U1").Select ActiveCell.FormulaR1C1 = "Month (November 13)" Range( _ "B5,B7,B13,D5,D7,D13,F5,F7,F13,H5,H7,H13,J5,J7,J13,L5,L7,L13,N5,N7,N13,P5,P7,P13,R5,R7,R13" _ ).Select Range("R13").Activate ActiveWindow.SmallScroll Down:=6 Union(Range( _ "D30,F22,F24,F30,K22,K24,K30,N22,N24,N30,P22,P24,P30,B5,B7,B13,D5,D7,D13,F5,F7,F13,H5,H7,H13,J5,J7,J13,L5,L7,L13,N5" _ ), Range("N7,N13,P5,P7,P13,R5,R7,R13,B22,B24,B30,D22,D24")).Select Range("P30").Activate Selection.Replace What:="H", Replacement:="I", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False Sheets("Australian Summary (1)").Select Range("B5,B7,B13").Select Range("B13").Activate ActiveWindow.SmallScroll Down:=-9 Range( _ "B5,B7,B13,D5,D7,D13,F5,F7,F13,H5,H7,H13,J5,J7,J13,L5,L7,L13,N5,N7,N13,P5:P6,P7,P13,R5,R7,R13,B22,B24" _ ).Select Range("B24").Activate ActiveWindow.SmallScroll Down:=3 Union(Range( _ "D30,F22,F24,F30,K22,K24,K30,N22,N24,N30,P22,P24,P30,B5,B7,B13,D5,D7,D13,F5,F7,F13,H5,H7,H13,J5,J7,J13,L5,L7,L13,N5" _ ), Range("N7,N13,P5:P6,P7,P13,R5,R7,R13,B22,B24,B30,D22,D24")).Select Range("P30").Activate Selection.Replace What:="H", Replacement:="I", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False ActiveSheet.Next.Select ActiveSheet.Next.Select Range("E8:E9,E12,E17:E20").Select Range("E17").Activate ActiveWindow.SmallScroll Down:=9 Selection.Replace What:="H", Replacement:="I", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False
Bookmarks