G
Guest
I have a strange problem -- the macro is not selecting, copying or pasting to
the correct ranges. When I do a F8 step by step debug review, it seems as if
it actually skips the Range(...).Select code.
The new select and paste ranges that are not be selected properly were
edited from previously coded ranges -- the macro is still selecting the old
ranges but the ranges are not coded in this macro! how do I fix this?
thanks.
Steve
Sub Set_Price()
'
' Set_Buyback_Price Macro
Sheets("A4_Targets").Select
Range("f13:f28").Select
Selection.Copy
Sheets("A1_Scenario Input").Select
Range("cq331").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Sheets("A4_Targets").Select
Range("f36:f51").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("A1_Scenario Input").Select
Range("cr301").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
the correct ranges. When I do a F8 step by step debug review, it seems as if
it actually skips the Range(...).Select code.
The new select and paste ranges that are not be selected properly were
edited from previously coded ranges -- the macro is still selecting the old
ranges but the ranges are not coded in this macro! how do I fix this?
thanks.
Steve
Sub Set_Price()
'
' Set_Buyback_Price Macro
Sheets("A4_Targets").Select
Range("f13:f28").Select
Selection.Copy
Sheets("A1_Scenario Input").Select
Range("cq331").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Sheets("A4_Targets").Select
Range("f36:f51").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("A1_Scenario Input").Select
Range("cr301").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False