Sometimes excel VBA code executes very slow. Sometimes it's really fast. I can't seem to pinpoint why. [more inside]
posted on May 21, 2008 - 8 answers

How to "text to column" a cell with multiple lines in Excel? [more inside]
posted on Jan 24, 2008 - 7 answers

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted on Jul 2, 2007 - 10 answers

Help me remove unwanted spreadsheet info - I want to archive a massive buch of data from years of Excel spreadsheets but, I don't want to save all the extra gumph associated with macros and links in spreadsheets. [more inside]
posted on Jan 15, 2007 - 10 answers

MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]
posted on Dec 27, 2006 - 3 answers

I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
posted on Sep 1, 2005 - 5 answers

I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
posted on May 4, 2005 - 31 answers

Is there a plug-in or macro for Excel v.X or Excel 2004 for Macintosh that adds PivotChart (from Excel 2003 for Windows) functionality or compatibility?
posted on Jan 13, 2005 - 2 answers

Is there any way to make Excel macros less stupid? [MI]
posted on Jan 5, 2005 - 16 answers