M
Mick Jennings
Hi all,
Recently started new job where the standard is Excel 2003 SP2.
I have a worksheet which is automatically populated and formatted from VBA,
based on data extracted from a directory-full of spreadsheets. All works ok,
except when I sort the resulting worksheet the borders don't move. Patterns
etc move fine, but the borders stay where they were, leaving an ugly mess.
Exactly the same happens whether the sort is triggered from code or from the
menus.
Anyone seen this before ?
Recently started new job where the standard is Excel 2003 SP2.
I have a worksheet which is automatically populated and formatted from VBA,
based on data extracted from a directory-full of spreadsheets. All works ok,
except when I sort the resulting worksheet the borders don't move. Patterns
etc move fine, but the borders stay where they were, leaving an ugly mess.
Exactly the same happens whether the sort is triggered from code or from the
menus.
Anyone seen this before ?