![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 45
|
What is "Argument not optional?"
|
|
|
|
|
|
#2 |
|
New Member
Join Date: Apr 2002
Posts: 3
|
This usually means that you are trying to get the code to do something that it can not do. For instance you are trying to make a msgbox = something.
Take a closer look at the documentation on how the argument is supposed to look. You may want to cut and paste the code where the error is occurring on here. Abbo |
|
|
|
|
|
#3 |
|
New Member
Join Date: Apr 2002
Posts: 45
|
Call FillDebitRecord(strBookBatch, strBookDeploy, intDebitCounter, intDeployCounter)
Call FillCreditRecord(strBookBatch, strBookDeploy, intCreditCounter, intDeployCounter) Call FillDescriptionRecord(strBookBatch, strBookDeploy, intDescriptionCounter, intDeployCounter) intDebitCounter = intDebitCounter + 2 intCreditCounter = intCreditCounter + 2 intDescriptionCounter = intDescriptionCounter + 2 intDeployCounter = intDeployCounter + 1 Wend ' fill the last line with a credit record plus the total amount Call FillLastRecord(strBookBatch, strBookDeploy, intDescriptionCounter, intDeployCounter) |
|
|
|
|
|
#4 |
|
Board Regular
Join Date: Feb 2002
Posts: 97
|
To me that means you are calling a function/subroutine/procedure that requires an argument.
For example: str The str function converts a number to a string, you cannot call that function without "passing" a number as an argument. For example: str(35) would return 35 as a string. Therefore, dim strString as string dim intInt as Integer intInteger = 35 strString = str(intInteger) You are probably missing an argument in one or all of your Calls. Hope this helps. [ This Message was edited by: charlie79 on 2002-04-23 10:22 ] |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|