Any tips for streamlining the following 3 macros into 1 tidy macro please: -
Sub priorforecastsOTL()
Dim current
current = Sheet5.Range("H3")
Sheet3.Select
Range("J3", current).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Selection.EntireColumn.Hidden = True
Sheet3.Range("B3").Select
End Sub
Sub priorforecastsSUPP()
Dim current
current = Sheet5.Range("I3")
Sheet1.Select
Range("M3", current).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Selection.EntireColumn.Hidden = True
Sheet1.Range("B3").Select
End Sub
Sub priorforecastsCONTJRN()
Dim current
current = Sheet5.Range("J3")
Sheet6.Select
Range("I3", current).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Selection.EntireColumn.Hidden = True
Sheet6.Range("B3").Select
End Sub
Many thanks
Sub priorforecastsOTL()
Dim current
current = Sheet5.Range("H3")
Sheet3.Select
Range("J3", current).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Selection.EntireColumn.Hidden = True
Sheet3.Range("B3").Select
End Sub
Sub priorforecastsSUPP()
Dim current
current = Sheet5.Range("I3")
Sheet1.Select
Range("M3", current).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Selection.EntireColumn.Hidden = True
Sheet1.Range("B3").Select
End Sub
Sub priorforecastsCONTJRN()
Dim current
current = Sheet5.Range("J3")
Sheet6.Select
Range("I3", current).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Selection.EntireColumn.Hidden = True
Sheet6.Range("B3").Select
End Sub
Many thanks