Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the same code over and over with different variables - but it's
only working the first 5 times. Instance 6,7 and 8 don't work - and I can't figure it out. Here's all the code : Sub PasteClear() ' ' PasteClear Macro ' Macro recorded 7/31/2006 by Jeremy ' ' Sheets("Item List").Select Range("E2:E19").Select Range("E19").Activate Application.CutCopyMode = False Selection.ClearContents Range("E2").Select End Sub Sub HATOpaste() ' ' HATOpaste Macro ' Macro recorded 7/31/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("A3") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("A3:A18").Select Range("A18").Activate Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub Sub PlenumPaste() ' ' PlenumPaste Macro ' Macro recorded 7/31/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("b4") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("B4:B20").Select Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub Sub DamperSleevePaste() ' ' DamperSleevePaste Macro ' Macro recorded 7/31/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("c5") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("C5:C16").Select Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub Sub HFSpaste() ' ' HFSpaste Macro ' Macro recorded 7/31/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("c19") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("C19:C22").Select Application.CutCopyMode = False Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub Sub SealLockPaste() ' ' SealLockPaste Macro ' Macro recorded 7/31/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("d4") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("D4:D16").Select Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub Sub TeeStandPaste() ' ' TeeStandPaste Macro ' Macro recorded 7/31/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("b24") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("B24:B25").Select Application.CutCopyMode = False Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub Sub QuickLockPaste() ' ' QuickLockPaste Macro ' Macro recorded 8/1/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("d19") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("D19:D31").Select Range("D30").Activate Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub Sub LSCPaste() ' ' LSCPaste Macro ' Macro recorded 8/2/2006 by Jeremy ' ' If Sheets("Item List").Range("E2").Value = Sheets("Item List").Range("c25") Then Exit Sub Application.ScreenUpdating = False PasteClear Range("C25:C28").Select Selection.Copy Range("E2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("E2").Select Sheets("Quote").Select Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create list of unique instances from list of multiple Instances | Excel Worksheet Functions | |||
Excel Addin works that works on a template workbook | Excel Programming | |||
it works, it doesn work, its works....and so on. | Excel Programming | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
Is there an easy way to replace list A instances with list B instances (sorted lists). | Excel Programming |