Wanted: Your favorite Excel macros

Gail Perry, our managing editor, is looking for contributions to a new book she is penning about Excel macros. The tome is to be written for people who are new to writing macros, so she's looking for basic macros that are useful to a wide range of business settings and that can be either recorded or programmed using straightforward techniques.

If you would like to have your favorite macros included in her book, please send an Excel worksheet containing the macro or simply an e-mail containing the code to Gail at gperry@accountingweb.com with "Excel macro submission" as the subject line. Please include a brief description of how the macro can be used in practical settings and how the macro was recorded or tips for programming. Also say how you you would like your name to appear in the book's acknowledgements.

The book is scheduled for publication in September 2008. Much of the work that goes into it - as well as previous VBA contributions to this site - will be featured in further updates to AccountingWEB's Excel Zone.

You may like these other stories...

Accountants who specialize in forensic and valuation services point to electronic data analysis, or big data, as the most pressing issue they’ll face in the coming months, according to results of a new survey released...
As complex as federal tax can get, at least you're only dealing with one agency: the IRS. But when you get into state and local sales tax, you're coordinating hundreds of jurisdictions that are constantly changing....
All that was needed on Tuesday was a voice vote for the House of Representatives to pass a bill that would prevent state and local governments from taxing access to the Internet.Now the ball is in the Senate’s court....

Upcoming CPE Webinars

Jul 31
In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
Aug 5
This webcast will focus on accounting and disclosure policies for various types of consolidations and business combinations.