Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link individual sheet to one sheet in another workbook | Excel Discussion (Misc queries) | |||
Locking Code In Individual Macros | Excel Discussion (Misc queries) | |||
linking of macros with other workbooks. need to stop it! | Excel Discussion (Misc queries) | |||
Linking and/or macros | Excel Worksheet Functions | |||
Macros and Linking | Excel Worksheet Functions |