Compile error with collection

[Xmarksthespot]

I have a sub whereI declare and set a collection (Cat_colw) which consists of a number of 3x3 arrays.<o></o>
I have a set ofvariables (gp1,gp2,gp3,…) that represent a 3x3 range of cells.<o></o>
I use thestatement: gp2.Value = Cat_colw(1) , to enterthe values of the array Cat_colw(1) intothe range gp2.<o></o>
This works fineif I do this in the same sub, but when I put this statement in a different suband make a call to it I get the error ------ <o></o>
<o> </o>
Compile Error<o></o>
Sub or Functionnot defined.<o></o>
<o> </o>
I’m a completebeginner so please excuse me if this is such a trivial task<o></o>
Thank you

 

[ScottR]

Variables declared within one procedure or function are generally not available to other procedures unless they are passed (best option, generally underused) or declared at a higher (eg module) level. Have a read of this

Understanding Scope

 

[GTO]

Please include the offending code, using [code]'...your code here[/code] like:

'...your code here

 

[wideboydixon]

Variables are declared "local" within a sub which means they can't be accessed from other subs unless you pass them as parameters. Move the declaration of Cat_colw to the top of the module above all sub definitions and that will make it available to other subs in that module. E.g.:

Dim Cat_colw As New Collection
Sub sub1()
'...
' You can use Cat_colw here
'...
End Sub
Sub sub2()
'...
' You can use Cat_colw here as well
'...
End Sub

WBD