Hay all,
I am working in Excel 2010, I created 2 Macros that copy colored cells from one worksheet to another, and they work fine. I also created a Data Valadiation drop down list and I am calling the Macro from with in the Data Validation list. The script runs but is cycles over and over until it eventually fails. can someone please let me know if I am donig something wrong here, thanks.
Data Validation list Code:
[VBA]Select Case Range("C4")
Case "DC OFFICE"
DC
Case "LA OFFICE"
Case "NY OFFICE"
Case "MU OFFICE"
MU
End Select
End Sub[/VBA]
MACRO CODE
[VBA]Sub DC()
'
' DC Macro
'
'
Sheets("Sheet3").Select
Range("C2:H8").Copy
Sheets("Sheet1").Select
Range("C6:H12").PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
ActiveSheet.Paste
Application.CutCopyMode = False
Range("C6").Select
End Sub[/VBA]