I have a number of macros that I am using to perform a number of functions
within a workbook.
As part of that, I am using code to name cells with the idea that I would be
able tor reference the cell values later. According to the vba intermediate
window it works - until that macro ends. The very next macro that runs, even
within the module, does not retrieve the info from the cell referenced by
name.
I have no idea what I am doing wrong. I would try using a "public"
statement except I can't get those to work either. As far as I can tell,
their is no difference in syntax between a public statement and a dim
statement other than the word "public" instead of "dim".
The public thing may be a red herring anyway.

Please help!