subroutine variable decleration issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christmas May - 30 Jun 2006 22:56 GMT

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

Reply to this Message

Norman Jones - 30 Jun 2006 23:03 GMT

Hi Chritmas,

Try:

Sub subroutine2(Optional rng As Range)

If rng Is Nothing Then Set rng = Range("A1:B2")

> Also are these routines public or private?

That depends on the required scope.

Lokk in VBA help for 'Scope', 'Private' and 'Public'

---
Regards,
Norman

> The following works:
>
[quoted text clipped - 9 lines]
>
> Christmas May

Reply to this Message