Hi there,

A month or so ago I created a macro by recording and saved it and have been
using it well. Until recently the results have been incorrect. part of the
macro is sorting the different products into groups and for some reason it is
doing this incorrectly. Every time I run the macro the sorting results are
different from the previous run and the information on the sorting is the
same always.

Any ideas ??
--
Niall

Niall, recorded macros are just a starting point. They often refer to the
wrong ranges when you want to run them on a different data set. Sometimes
they are set for relative recording and some times absolute. It sounds like
you need to do a lot of editing to your macro to get it work.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Richie" <(E-Mail Removed)> wrote in message
news:47CDF786-3843-4CB3-B059-(E-Mail Removed)...
> Hi there,
>
> A month or so ago I created a macro by recording and saved it and have
> been
> using it well. Until recently the results have been incorrect. part of
> the
> macro is sorting the different products into groups and for some reason it
> is
> doing this incorrectly. Every time I run the macro the sorting results
> are
> different from the previous run and the information on the sorting is the
> same always.
>
> Any ideas ??
> --
> Niall