Why can I not sort the data after a certain line of data

[leanne2011]

Please see code below - why after "Return" can I not sort the data ?
any ideas ?

Thanks

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Impossible to say without seeing the workbook in question. Would you upload it please.

As an aside the macro looks as though it's been captured with the Macro recorder. This is fine for starters but code captured in this way is almost always too bloated and can be simplified considerably.

[leanne2011]

Hi Richard

Yes I am a novice and my intention is to get the code on paper and look for ways to make it smarter afterwards - as much as I can do.

Thanks for helping - I attach the data to run the code ontest script 2.xls

[Richard Buttrey]

Hi,

The code in the workbook is not consistent with that which you showed in your original post.

Can we go back to basics and can you describe what you are trying to achieve. It seems that you want to start with your data sheet and then do something with it. If you can describe in a narrative form what that something is and manually create the Report sheet that you expect to see after the macro has processed then no doubt we can assist further,

[romperstomper]

No code after Return will be processed since control passes back up to the line following the Gosub statement (who on earth uses Gosub these days?? [Edit: never mind - now I know who!]) and there's an Exit Sub preceding the GetDueDate label.