Excel VBA

<p>Data processing, dynamic reporting, and workbook automation.</p>

Solved December 1, 2012

Dumping variant array to range – VBA excel error 1004

I'm using vba for Excel in order to save data into a array by: dim allPosts As Variant allPosts = Range("A2:J5000") after that I'm…

thumb_up 12 trending_up 5

Solved November 23, 2012

I have a file on .csv format and from A-S columns, it has some records like a table. My complete program will insert/remove/delete/add some…

thumb_up 13 trending_up 4

Solved November 18, 2012

I've got a large table of data in an Excel spreadsheet that, essentially, can be considered to be a collection of values for individuals…

thumb_up 9 trending_up 8

Solved November 4, 2012

I have an excel file (Excel 2003 / xls format) and I want to send it by email with c#. My code send it…

thumb_up 5 trending_up 8

Solved October 31, 2012

How do I select the entire column after a specific cell? For example, I would like to select the entire column after C24 so…

thumb_up 7 trending_up 4

Solved October 31, 2012

I have a column of text values with repeated values. I want to create a new column of unique values (no repeats) and a…

thumb_up 15 trending_up 8

Solved October 30, 2012

I'd like to sort rows in a sheet by one of string column. I tried to achive that using Sheet.shiftRows method, but I cannot…

thumb_up 4 trending_up 8

Solved October 26, 2012

I want to count number of rows in Sheet1, from the Sheet2 code module. In the sheet1 code module, the following code works fine…

thumb_up 7 trending_up 4

Solved October 24, 2012

I am trying to run a single macro which performs functions on multiple worksheets. Let's say I have assigned the macro button on worksheet…

thumb_up 7 trending_up 7

Solved October 20, 2012

I'm trying to run a macro that selects blank cells in a table column and deletes the entire row. The script below does everything…

thumb_up 6 trending_up 6