View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christmas May[_2_] Christmas May[_2_] is offline
external usenet poster
 
Posts: 63
Default subroutine variable decleration issue

The following works:

sub subroutine(optional Byval strVariable as string = "Default String")

Can I do something similar to the following, which doesn't work?

sub subroutine2(optional byval rngVariable as range = range("A1:B2"))

Also are these routines public or private?

Thanks in advance,

Christmas May