linking individual macros on the same sheet
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.
"Quandary 11 - 3 - 07" wrote:
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
|