linking individual macros on the same sheet

  • Thread starter Quandary 11 - 3 - 07
  • Start date
Q

Quandary 11 - 3 - 07

How can I have 2 individual macros with same functions, but different ranges ,
work together at the same time , on the same sheet.

both work well individually, But not together.

Sequence is---- Reset, Up, Down, Auto .

Each of the set of 4 Macros Has Different Name.
Thank You
 
J

Joel

You probably are using .select to highlight cells. You do not need to to a
select in most cases. Just do the operation directly. for exaple

Range("a3:b10").select
selection.copy

Instead just copy
Range("a3:b10").copy

The select will highlight the cells "a3:b10" which will change the current
selection. I suspect the two macros are conflicting because one is changing
the active selection which the second uses. try to eliminate the .select.
 
Top