I want to automate certain tasks on excel file. I decided to use the record macros function, but although it performs first few tasks, macros don't sort and remove the duplicates as I recorded. I decided to debug it by recording smaller steps and found macros don't sort. Any help?
When you record macros it creates individual subroutines fo each bit you record. What you need to do then is taken all these separate sections of code and put them into a sub that then does what you want it to do. You can then delete the recorded subs and tidy up your code.