excel-vba

136 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.

Solved December 21, 2011

Replacing multiple invalid characters in a sheet name

I am writing a fairly large macro which ends by saving the workbook with a name that the user inputted earlier on. I am…

thumb_up 7 trending_up 3

Solved December 12, 2011

I have a list of data, let's say client information (Name, Email, Amount Owing etc.), stored in an Excel worksheet . My aim is…

thumb_up 8 trending_up 3

Solved December 7, 2011

I have some long processes that require notifications to the user at successive stages, so that he doesn't get to believe Excel has crashed…

thumb_up 8 trending_up 3

Solved November 25, 2011

I have a "duration" column in an Excel sheet. Its cell format always changes — I want convert the duration from minutes to seconds,…

thumb_up 55 trending_up 29

Solved November 16, 2011

The below VBA in MS Access is run to format my Excel sheet. However, it is formatting to Number with 2 decimal places. How…

thumb_up 11 trending_up 5

Solved November 2, 2011

What is the difference between trim and trim$ in vba? Accidentally today when I used left and trim functions in vba, The compiler said…

thumb_up 16 trending_up 8

Solved October 7, 2011

I am looking to implement a VBA trie-building algorithm that is able to process a substantial English lexicon (~50,000 words) in a relatively short…

thumb_up 17 trending_up 11

Solved August 16, 2011

I have a simple problem that I'm hoping to resolve without using VBA but if that's the only way it can be solved, so…

thumb_up 22 trending_up 11

Solved July 28, 2011

I am trying to count the number of rows in a spreadsheet which contain at least one non blank value over a few columns:…

thumb_up 14 trending_up 9

Solved July 28, 2011

So, what I want to do, generally, is make a copy of a workbook. However, the source workbook is running my macros, and I…

thumb_up 31 trending_up 14