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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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, 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA Macro to do this? 19
Excel macro to aid visual clarity? 7
MACRO RUN random percentage and copy of column values 1
Macro Not Changing Date Values 7
Macro to copy value in field and insert it into filter 2
Macro to add Multiple rows in same sheet 1
Macro Help 3
"Run" code causing macros to run twice and/or stopping 2

Back
Top