Greetings !

I'm afraid I have plagued you all for some while with what
seemed to be intractable problems, and I have been very
grateful for frequent very useful advice from many of you -
advice which alas too often seemed not to work - for me.

I THINK I have now discovered the problem: Some while
ago, I asked about AddIn files, and I then took the file I
had and "SavedAs" what I thought was an AddIn, by simply
changing the suffix from .xls to .xla, rather than
clicking on the row beneath, asking which type of file to
save it "As". I have ended up with a quasi-Addin, that
sometimes works as a true AddIn, but sometimes not, and it
may also be this that has caused frequent crashes of Excel.

It was a spreadsheet, with half-a-dozen worksheets, all of
which worked O.K. - so in THIS respect, it acted just like
a worksheet.

I am now trying to separate the "Worksheet" part from
the "AddIn" part.

O.K. - so here is my current challenge !

In the AddIn part, I have modules -
"Constants", "CommonVariables", "VariableTypes"
and "PublicDeclarations", but when I RUN the two parts
together, i.e. when I load the spreadsheet, Excel runs OK
until it reaches "HIP(Ali, 1)", which refers to an array
variable declared in the "Common Variable" module
by "Public HIP(2, 50) As HorizIntersPts"

At this point, Excel creaks to a halt with the message -
"Compile Error - Sub or Function not defined".

Now, this worked FINE until I split the two parts.

What am I doing wrong ?