Yes it is, Thank you.

When Mark007 wrote the PHP routine that formats the text between CODE Tags he included an auto-indent function. If you look at the code you just posted you will notice that the indents are stair stepping. This is due to many words without spaces betweenthem. I am not sure if this is a side effect of the Copy Paste and the Editor, or if it is reflective of your code. I noticed the same thing in, IIRC, the same places in your first post.

Other than that, your code looks very well structured and thought out. If the typos are actually in your code these suggestions will help:

In the VBA Editor, click on the Tools menu Options. On the Editor tab, put a check mark in every box in the Code Settings Frame. OK the Options dialog and at the top of all your existing code pages put the words "Option Explicit." The Require Variable Declarations Option you checked will add this to any new pages created.

In the VBA editor, Ctrl+H will bring up the Find And Replace Dialog. I suggest that you first Find and Replace the following
  • "End" with "End " (End + space)
  • "Then" with " Then" (space + Then)
  • "Next" with "Next " (Next + space)

That should fix %99 of the typos I see in your posted code.

Another troubleshooting technique VBA has is Compile on Demand. The menu item "Debug" has the Compile Command. The Compiler will stop when it notices an error and Highlight the line it stopped at. If you can't see an error in the highlighted line, look at all the code before the line.

Another technique I have used is Mark007's auto-indent. In the VBA Express Testing Forum, start a new thread. Use the "Go Advanced" button to open the Advanced Editor which has a Preview button. Paste your code with CODE Tags and Preview the results. If you see stair stepping indentation, you will have a very good clue as to where you missed an End or Loop Statement.