Home

Automating tasks in excel - need help

Sumit_Narang
Occasional Visitor

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?

1 Reply

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 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies