Thread: Public Array
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Public Array

Tom,

I should have mentioned "to all procedures within this module".
The point wasn't whether to declare it public or private but rather to
declare it (at module level) and not confuse it with Sub MyArray().


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Ogilvy" wrote:

I think you would need to declare it Public.

Public myArray(10,10) as string

sub do1()
myArray(2,2)="john"
end sub

sub get1()
msgbox myArray(2,2)
end sub

to see it in other modules.