Macro returns Argument not optional error

[tigerdel]

I have call code for a button added to a new custom ribbon

Sub Raw_Data(control As IRibbonControl)
Call Raw_Data
End Sub

This supposed to run a macro called Raw_Data when the icon is clicked
However this returns Argument not optional error

Any help would be greatly appreciated

 

[Jimmypop]

Hi there

Are you calling Raw_Data or Raw_Date...

 

[tigerdel]

Hi there

Are you calling Raw_Data or Raw_Date...

The macro is called Raw_Data

 

[Jimmypop]

Did you edit your first post? I though I saw you said Raw_Date in the line This supposed to run a macro called Raw_Data when the icon is clicked...

 

[tigerdel]

Did you edit your first post? I though I saw you said Raw_Date in the line This supposed to run a macro called Raw_Data when the icon is clicked...

Yes I did - when you asked your question I realised that there was an error in what I had typed

 

[Jimmypop]

Ok thanks...

What about...

Sub Raw_Data(control As IRibbonControl)
Call Raw_Data()
End Sub

 

[tigerdel]

Same error

 

[RoryA]

Don't use the same name for both routines. Change one of them.

 

[tigerdel]

Don't use the same name for both routines. Change one of them.

Perfect - thank you