Accessing array in a class module

My operating system is Windows 7 Home Premium, using Microsoft Office 2010. I have created a string class module called clsTest, having 15 properties. I entered data to the class module through the following code which reads in the data, prints it to a scratch pad sheet, sorts it (I understand you can sort the array internally) using the scratch pad, prints the sorted array to another worksheet.
All of the code works fine. My problem is I can't seem to get the array from the class module. I will be having several classes for various other string arrays and will need access to them for further manipulation and/or printing. I am a novice in working with class modules any help would greatly be appreciated.

Please Login or Register  to view this content.

Hi, please amend your [code/]Please Login or Register to view this content.[/code][/B].

Hi chipnputt ,

When you say you can't get your values out of the class module it sounds like a SCOPE problem. Here is some info on Scope at:
http://www.cpearson.com/Excel/Scope.aspx

I'm not completely sure about Class Modules and how they fit in this big picture but I do know if you put code behind an individual sheet it can't be used to work on other sheets, without some tricks.