When an Export to Excel has a visually empty cell in Excel, IT SHOUL BE EMPTY/BLANK.
It is unclear what SAGE is doing with the output as Visually empty cells are not being recognized as BLANK according the F5 (GoTo) Special, Blank Cells. The cells are of Zero Length according to the LEN function.
Applying a Filter to show only these empty cells and Clearing ALL does restore the expected ability to use the GoTo function. However this should be an unnecessary step.
BRIAN SPILLER
