Sort, Copy, and Paste macro, must execute twice to work

B

B. CLAY

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy a range of cells and paste into a new workbook in differentcolumns 3
Multiple worksheet Copy Paste Macro 2
macro to filter 6
Macro - copy and paste value 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to Copy / paste from 1 workbook to another 6
Sort / Copy Macro 2
Macro to create newsheets 3

Top