Hi everyone,
I'm getting an error 400 when I'm running the following code:
Sub Run_Sensitivities()
' This macro is designed to automatically calculate sensitivities within the sensitivities worksheet.
' Code for the calculation of WTI sensitivity.
If Range("Switch_WTI") = "On" Then
Range("Table_WTI").Select
Selection.Table RowInput:=Range("Sensi_WTI")
Calculate
Range("Clear_WTI").Select
Selection.Copy
Selection.PasteSpecial Paste:=x1Values, Operation:=x1None, Skipblanks:=False, Transpose:=False
Else
End If
End Sub
How do I get rid of the error 400?
Thanks,
Paula
Bookmarks