Can you supply a sample workbook with this setup since it is different from post #1?

Also, if your last cell is F26, but yet the end is showing F2626, then you must have blank rows beyond F26 that aren't really blank.

What do you get when you select Ctrl + End?