Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default linking individual macros on the same sheet

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   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link individual sheet to one sheet in another workbook dfield Excel Discussion (Misc queries) 1 March 12th 06 02:26 AM
Locking Code In Individual Macros Carl Bowman Excel Discussion (Misc queries) 2 May 19th 05 06:05 PM
linking of macros with other workbooks. need to stop it! KyWilde Excel Discussion (Misc queries) 1 March 10th 05 07:13 PM
Linking and/or macros Frustr8 Excel Worksheet Functions 0 January 17th 05 10:27 PM
Macros and Linking Chris Excel Worksheet Functions 0 December 1st 04 04:15 PM


All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"