I have a dynamic named range that changes based on what month I select from a drop down list. Basically it says all months after the selected is considered an Outlook, and everything else is "Actual". I want to update all the "Actual" columns (H5:?500) then overwrite it as values to to keep my file performance decent. I only have formulas in one column range (g5:g500). For reasons I can't understand, my macro is only copying formulas to the first column in that named range. Can some one please help? Below is a sample of my code. I am a total noob with VBA.
Kind Regards
Roger
Sheets("BM - Base OL Walk").Select
ActiveSheet.Range("$A$12:$A$500").AutoFilter Field:=1
Range("G5:G500").Select
Selection.Copy
ActiveSheet.Range("actuals_walk").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("C3").Select
Kind Regards
Roger
Sheets("BM - Base OL Walk").Select
ActiveSheet.Range("$A$12:$A$500").AutoFilter Field:=1
Range("G5:G500").Select
Selection.Copy
ActiveSheet.Range("actuals_walk").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("C3").Select