Hi Guys,
I have a workbook with 5 sheets.
I have a main sheet with some bottom's that i assigned macros. Two buttons have macros that are in module 1.
Other button have assign macro in sheet3.
Now, i'm trying to add another button with another macro in sheet 3, but when i click it show me a error 400. If i enter in vba and use F8, appeared error 1004.
This is code:
Sub Apagar_Cor_L2()
'
' Apagar_Cor_L2 Macro
'
'
Range("C10:AC60").Select
Application.CutCopyMode = False
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
With Selection.Font
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
End With
Range("AG23").Select
Range("F100:F164").Select
Selection.Copy
Range("F10,J10,N10,R10,V10,Z10").Select
Range("Z10").Activate
ActiveSheet.Paste
Range("C166:AC166").Select
Application.CutCopyMode = False
Selection.Copy
Range("C13,C17,C21,C25,C29,C33,C37,C41,C45,C49,C53,C57").Select
Range("C57").Activate
ActiveSheet.Paste
End Sub
What am i doing wrong?
Regards,
migueltomas
Bookmarks