Styjun

Calculus, Water Poured into a Cone: Why is Derivative Non-linear?

Alien life interbreeding with Earth life

Converting Geographic Coordinates into Lambert2008 coordinates

Story where diplomats use codes for emotions

Copy group of files (Filename*) to backup (Filename*.bak)

Is there a way to convert blue ice back into packed ice?

Origin of the convolution theorem

Cooking a nice pan seared steak for picky eaters

Are Valenar elves and Aereni elves different races of elves?

How do ohm meters measure high resistances?

Sharing referee/AE report online to point out a grievous error in refereeing

Is it okay to fade a human face just to create some space to place important content over it?

How did Lefschetz do mathematics without hands?

How do I tell the reader that my character is autistic in Fantasy?

Sentence editor

Does a lens with a bigger max. aperture focus faster than a lens with a smaller max. aperture?

Translation of the Sator Square

Reusable spacecraft: why still have fairings detach, instead of open/close?

My colleague is constantly blaming me for his errors

On what to compliment someone with anorexia in order to improve their body image?

Discworld quote about an "old couple" who having said everything to each other, can finally go about living their lives

I just started should I accept a farewell lunch for a coworker I don't know?

How does mmorpg store data?

Why would anyone even use a Portkey?

VBA Test if optional variant exists

Is there a way to crack the password on an Excel VBA Project?VBA Error: “Compile error: Expected End Sub”Properly Handling Errors in VBA (Excel)Compilation-error while passing Variant argument ByRef in VBAHow to avoid using Select in Excel VBAHow to test if some of the optional parameters of an excel-VBA procedure is supplied?“Block if without end if” error VBADetermining the full type of a variablePassing Variant ByRef in VBA Excel 2007VBA User Form does not recognize if function?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I've got a method:

Public Sub Method1(Optional Append As Variant)

And I want to check to see if the Append argument was passed or not, so I was trying:

Public Sub Method1(Optional Append As Variant)
 If Not Append Is Nothing Then ... End If
End Sub

But this conditional testing only works if Append was passed, otherwise Append just doesn't exist and we get an error.

Is there a way to test this without relying on "On Error Goto" ?

excel vba

share|improve this question

asked Mar 25 at 14:52

jamheadartjamheadart

1,54122 gold badges88 silver badges3030 bronze badges

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  IsMissing
  
  – shahkalpesh
  Mar 25 at 14:57
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  You need to use IsMissing. eg. If IsMissing(Append) then
  
  – Freeflow
  Mar 25 at 14:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You can set a default to Optional Append as variant=0 and test that way also.
  
  – Nathan_Sav
  Mar 25 at 14:59
  

  
  
  
  

add a comment | 

0

I've got a method:

Public Sub Method1(Optional Append As Variant)

And I want to check to see if the Append argument was passed or not, so I was trying:

Public Sub Method1(Optional Append As Variant)
 If Not Append Is Nothing Then ... End If
End Sub

But this conditional testing only works if Append was passed, otherwise Append just doesn't exist and we get an error.

Is there a way to test this without relying on "On Error Goto" ?

excel vba

share|improve this question

asked Mar 25 at 14:52

jamheadartjamheadart

1,54122 gold badges88 silver badges3030 bronze badges

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  IsMissing
  
  – shahkalpesh
  Mar 25 at 14:57
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  You need to use IsMissing. eg. If IsMissing(Append) then
  
  – Freeflow
  Mar 25 at 14:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You can set a default to Optional Append as variant=0 and test that way also.
  
  – Nathan_Sav
  Mar 25 at 14:59
  

  
  
  
  

add a comment | 

I've got a method:

Public Sub Method1(Optional Append As Variant)

And I want to check to see if the Append argument was passed or not, so I was trying:

Public Sub Method1(Optional Append As Variant)
 If Not Append Is Nothing Then ... End If
End Sub

But this conditional testing only works if Append was passed, otherwise Append just doesn't exist and we get an error.

Is there a way to test this without relying on "On Error Goto" ?

excel vba

share|improve this question

asked Mar 25 at 14:52

jamheadartjamheadart

1,54122 gold badges88 silver badges3030 bronze badges

Public Sub Method1(Optional Append As Variant)
 If Not Append Is Nothing Then ... End If
End Sub

share|improve this question

asked Mar 25 at 14:52

jamheadartjamheadart

1,54122 gold badges88 silver badges3030 bronze badges

share|improve this question

asked Mar 25 at 14:52

jamheadartjamheadart

1,54122 gold badges88 silver badges3030 bronze badges

asked Mar 25 at 14:52

jamheadartjamheadart

1,54122 gold badges88 silver badges3030 bronze badges

asked Mar 25 at 14:52

jamheadartjamheadart

1,54122 gold badges88 silver badges3030 bronze badges