Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have recorded a macro that runs fine when I use the Macro Run command, but
when I copy the macro text and assign it to a command button it gives an error. The following is the macro: It gets hung up on the 2nd line (Rows...) Any idea why it would work as a macro and not when placed into a command button? Sheets("Jacobs-Planning").Select Rows("1:343").Select Selection.Clear Range("B7").Select ActiveWindow.SmallScroll Down:=-30 Range("A5").Select Range("MasterData").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _ Sheets("Master Sheet").Range("A2:A3"), CopyToRange:=Range("A6"), Unique:= _ False Cells.Select With Selection.Font .Name = "Calibri" .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With With Selection.Font .Name = "Calibri" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With Range("H6").Select ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 7 ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 6 ActiveWindow.ScrollColumn = 7 ActiveWindow.ScrollColumn = 6 ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command button error | Excel Programming | |||
Error When Assigning a Macro to a Command Button | Excel Programming | |||
Automation Error when deleting command bar button | Excel Programming | |||
Command Button run-time error | Excel Programming | |||
Run-time error on command button | Excel Programming |