Good day, all.
EDIT: I've just found a missing line of code which solved the problem, so ignore this post.
Can anyone please give me a clue as to what is happening here.
While re-organizing the variables in a complex macro I have done something it takes exception to and it now completely ignores the variables declarations I have set up in a dedicated module containing nothing but public and global variable declarations and a few constants. I have tried shifting the code to a new module leaving the original empty but to no avail. I tried moving the code to the general section of the Workbook_Open event handler but it marked all the Constants (e.g. Public Const constSubSpecMarkerColumn as Byte = 3) in nasty bad-tempered red and refused to read any of it.
I am puzzled. (Emoji scratching head)
Ken