Hello All,
Below is a piece of the macro code that is bugging on me. I have it assigned to a dropdown menu located on Sheet1. All data is on Worksheet. If the dropdown menu is on the same sheet as the data, the macro works. But when I creat a new menu and assign the macro and define in the macro where the data is, I get error code 400.
Your insight would be appreciated.
Sub Graphing()
'
'
'
Select Case Range("Worksheet!CF5").Value
Case 1
Range("Worksheet!BT3:CD3").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("Worksheet!CF3").Select
ActiveSheet.Paste
Case 2
Below is a piece of the macro code that is bugging on me. I have it assigned to a dropdown menu located on Sheet1. All data is on Worksheet. If the dropdown menu is on the same sheet as the data, the macro works. But when I creat a new menu and assign the macro and define in the macro where the data is, I get error code 400.
Your insight would be appreciated.
Sub Graphing()
'
'
'
Select Case Range("Worksheet!CF5").Value
Case 1
Range("Worksheet!BT3:CD3").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("Worksheet!CF3").Select
ActiveSheet.Paste
Case 2