Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort, Copy, and Paste macro, must execute twice to work
I have a spreadsheet that has 4 subjects. I have a macro set up to sort on
subject 1 and then paste to workbook A. 2nd macro sorts on Subj 2 and then paste to workbook B. Then Subj. 3/workbook C, then Subj 4/workbook d. First two macros work fine then when I do Macro C, the first line of the sort in Macro B results is at the top of Subj 3 sort. Oddly if I then execute Macro C again, it's corrected. Something weird is going on? Any ideas? By the way all these macros are set up under a single macro. IE CTRL-M, executes MACRO A, B, C, D DOESN't work However, MACRO A, B, C, C, D DOES work |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort, Copy, and Paste macro, must execute twice to work
hi
post your code. regards FSt1 "B. CLAY" wrote: I have a spreadsheet that has 4 subjects. I have a macro set up to sort on subject 1 and then paste to workbook A. 2nd macro sorts on Subj 2 and then paste to workbook B. Then Subj. 3/workbook C, then Subj 4/workbook d. First two macros work fine then when I do Macro C, the first line of the sort in Macro B results is at the top of Subj 3 sort. Oddly if I then execute Macro C again, it's corrected. Something weird is going on? Any ideas? By the way all these macros are set up under a single macro. IE CTRL-M, executes MACRO A, B, C, D DOESN't work However, MACRO A, B, C, C, D DOES work |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort, Copy, and Paste macro, must execute twice to work
ALWAYS!! post your code for comments and suggestions.
-- Don Guillett Microsoft MVP Excel SalesAid Software "B. CLAY" <B. wrote in message ... I have a spreadsheet that has 4 subjects. I have a macro set up to sort on subject 1 and then paste to workbook A. 2nd macro sorts on Subj 2 and then paste to workbook B. Then Subj. 3/workbook C, then Subj 4/workbook d. First two macros work fine then when I do Macro C, the first line of the sort in Macro B results is at the top of Subj 3 sort. Oddly if I then execute Macro C again, it's corrected. Something weird is going on? Any ideas? By the way all these macros are set up under a single macro. IE CTRL-M, executes MACRO A, B, C, D DOESN't work However, MACRO A, B, C, C, D DOES work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why will my copy and paste button not work | Excel Worksheet Functions | |||
Why does this Macro not work - cut, copy and paste | Excel Discussion (Misc queries) | |||
copy paste between two instances does not work | Excel Discussion (Misc queries) | |||
Sort, Copy, Paste..without Autofilter..Anyone??? | Excel Worksheet Functions | |||
Data validation does not seem to work with copy/paste | Excel Discussion (Misc queries) |