<p>What are some macros that you have found useful in Visual Studio for code manipulation and automation? </p>

You might want to add in code snippets as well, they help to speed up the development time and increase productivity.
The standard VB code snippets come with the default installation. The C# code snippets must be downloaded and added seperately. (Link below for those)
As far as macros go, I generally have not used any but the working with Visual studio 2005 book has some pretty good ones in there.
C# Code snippets Link:
http://www.codinghorror.com/blog/files/ms-csharp-snippets.7z.zip
(Jeff Atwood provided the link)
HIH