View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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