Quote:
Thank you Fumei but I don't really know how to write my own macros.
|
Then this would be a good place to start.
Take the lines I posted and put them between a Sub and a End Sub. Something like:
Sub YourNameOfTheSubRoutine()
the lines of code here
End Sub
and paste it into the VBE. You have to put it in the document with the list - unless you want to tell the code to work with another document file.