THANK YOU PAUL!
I changed it to Dim lRowAxisData As Range, lRowAxisComment As Range, lRowMgmtData As Range, lRowMgmtComment As Range and everything worked. Yes, Option Explicit was supposed to be un-commented but I was experimenting and forgot to do that. If I had gone back to my Excel 2007 VBA Programmers Reference, page 43, Declaring Variable Type, I would have seen that I had fallen into the exact trap they said not to; not declaring a type for each variable even though they are on the same line.
Sure appreciate the help! I knew I was rusty but I didn't know it was that bad!!