argument not optional

  1. V

    Argument not optional - Dictionary and Classes

    Hello everyone! I'm fairly new to VBA, and I'm currently experimenting with Classes and Dictionaries. However I encountered a problem, that for once, I was not able to solve using the infinite amount of ressources available on the internet. Whenever I run my macro, I get the "argument not...
  2. Y

    Argument not optional - clear hyperlink

    Hi I encountered the Argument not optional error while trying to run the code below. Appreciate if anyone can point out my mistake. Thanks a lot guys. Sub Clear_Hyperlink() Dim Rng As Range, Cell As Range Set Rng = ActiveSheet.Range("a1:a7") For Each Cell In Rng If...
  3. H

    Macro Issue

    Please could anyone help me with this, it's for my dissertation and aims to delete all the data in a spreadsheet that isn't required (as it is a standardized set of data which is unneeded). I'm getting the error 'Compile error: Argument not optional' but have no idea why. Any help would be so...
  4. N

    Help With Passing Parameters to Subs (Compile Error: Argument not optional)

    Hello All, I am new to Excel VBA and have been trying to code a merge sort algorithm. I actually have two questions. The following code has been adapted from online examples, but whenever I try to run the code I get a compile error. I believe that the way in which I either try to Call the other...
  5. B

    Customised ContextMenus Not Working in 2007

    Hi, I've recently customised some of the contextmenus within Excel (2003), including the Cell and Query menus. This is working fantastically well, giving some better functionality. I've saved the workbook as an Add-In. I need to use the same code within Excel 2007 as well. The Add-In is there...
  6. P

    Ctrl-X Error

    Whenever I attempt to cut using CTRL-X in Microsoft Excel 2003, I get a Microsoft Visual Basic error: Argument not optional. To my knowledge I am not having any other problems. I am able right-click and choose cut or choose it from the Edit pull-down ... it is just the shortcut key that is not...
  7. S

    Argument not optional error

    I am trying to pass variables to a sub routine, which must then establish an log based on the variables. But I keep getting the following error: "Compile error: Argument not optional" As far as I understand this error indicates, that I have omitted a variable, but that is not the case. Can...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top