Problems with defining global variables

Hi,
I have three modules- A,B,C with the following code as seen below. When I try to run sub Main it crashes when it tries to call ReadData without any error messages even if I use On Error GoTo.... If I remove pix in the global definition it does not crash in ReadData on that line. But it still crashes on line with "sh(1)="name 1". What is wrong here? I need to use the variables in a lot of subroutines therefore I use Global.

Module A

Please Login or Register  to view this content.

Module B

Please Login or Register  to view this content.

Module C

Please Login or Register  to view this content.

Do you have any addins loaded? This sounds like your Excel is corrupted or an addin is, so Excel may need reinstalling - this isn't normal behaviour.

Another thought, are you using any windows APIS?

I have the following Add-Ins in Excel
Analysis-ToolPak
Analysis-ToolPak - VBA

and there are no Addins in VBA. The Add-In Manager is empty and I can not choose any.

I have the four first selection in References
Visual Basic for Applications
MS Excel 14.0 Object Library
OLE Automation
MS Office 14.0 Object Library