Automating tasks in excel - need help

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.



Related Conversations
IF statements and conditional formatting
clare1981 in Excel on
0 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
4 Replies