Hello tone640,
I have heard and read that Excel 2013 actually sucks! Some hold the same opinion about Excel 2007.
Personally I find Excel 2007 superior to Excel 2003. Don't know, or have or tried any newer versions yet, so I cannot give you my opinion of same.
Please try the attached WorkBook. Just maybe it has the answer to your specific Excel 2013 issue.
Notice that in my Code, I refer to the Sheet as an Object instead of a Sheet.
Hope that helps, as I am going totally "Blind" here. LOL
Bookmarks