Macro giving different results each time it is run - bugs maybe !?

R

Richie

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 ??
 
B

Bob Flanagan

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
 
Top