excel-vba

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

Solved April 16, 2012

Turn off marker shadow on vba-generated Excel plots

I'm porting some code I use to generate scatter plots in Excel from Win 7 / Excel 2010, to OS X / Excel 2011.…

thumb_up 5 trending_up 6

Solved April 13, 2012

If an Excel Workbook has many sheets and some of them have macros inside, the only way I have found to determine which sheets…

thumb_up 10 trending_up 7

Solved March 30, 2012

I am writing a macro that takes a list of names that are in an LDAP format converts them to First, Last (region). For…

thumb_up 10 trending_up 7

Solved March 21, 2012

I have an excel sheet which has some huge data. Data is organized as follows, A set of 7 columns and n rows; as…

thumb_up 6 trending_up 4

Solved March 20, 2012

I have 2 checkboxes, what i want to do is when i select one, the other 1 will be deselected, which means user will…

thumb_up 8 trending_up 3

Solved March 12, 2012

I have to count number of distinct values from a column and print it with the distinct value and count in another sheet. I…

thumb_up 7 trending_up 4

Solved March 9, 2012

A lot of the solutions here on SO involve using CountIf to find duplicates. When I have a list of 100,000+ values however, it…

thumb_up 9 trending_up 5

Solved March 6, 2012

I have a Do .. While loop in which two For.. loops are nested; the first For.. loop counts up from 1 to X,…

thumb_up 10 trending_up 6

Solved January 26, 2012

I want to have an array list in vba, hence I have a variant declared in excel vba like: Dim Students(10) as variant Now…

thumb_up 8 trending_up 6

Solved December 30, 2011

I am using VBA for Excel 2010 and randomly receiving the following error: Run-time error '1004': "The sort reference is not valid. Make sure…

thumb_up 4 trending_up 6