I would still like to understand why it didn't work but I did find a work around. I counted all the rows with values and set my range that way since I knew how many columns there were (and that would never change). So I set my range = (A5:W &lngCounter).
Still - if anyone can explain what...
Hello,
I know there have been numerous posts regarding a ghost instance of Excel being left behind (shows up as a process running in task manager) when formatting an Excel file from VBA (access). I am not using late binding and have tried to not leave any piece unattached to an already...