Home

Automating tasks in excel - need help

Highlighted
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
Highlighted

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
IF statements and conditional formatting
clare1981 in Excel on
0 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
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