Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting and applying the correct forumla | Excel Worksheet Functions | |||
Need urgent help selecting correct test!! | Excel Worksheet Functions | |||
Selecting the correct range | Excel Programming | |||
Selecting the correct number from a range of cells | Excel Worksheet Functions | |||
Selecting a range in code | Excel Programming |