Jan 05 2019 07:40 AM
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?
Jan 06 2019 04:13 AM
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.
Rich