Excel VBA

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

Solved January 9, 2014

Trim all cells within a workbook(VBA)

I have attempted to add functionality to an excel add-in ave been developing which trims the leading spaces at the end of used cells,…

thumb_up 8 trending_up 3

Solved January 7, 2014

I need help on my Excel sheet. How can I declare the following IF condition properly? if A1 = "n/a" then C1 = B1…

thumb_up 41 trending_up 21

Solved December 27, 2013

Are there formulas to convert data in a column to a matrix or to a row? And to convert from/to other combinations? What about…

thumb_up 11 trending_up 6

Solved December 19, 2013

I have macro, if I put in cell E1 name of the file, macro search trough C:UsersMarekDesktopMakro directory, find it and put the needed…

thumb_up 12 trending_up 2

Solved November 26, 2013

I have seen a lot of Topics to the "unable to get the match property of the worksheetfunction class" problem. But I can't get…

thumb_up 9 trending_up 3

Solved November 26, 2013

I was writing a routine to read from an Excel spreadsheet. I have just discovered thro that MS Excel spreadsheet that 1 microsoft second…

thumb_up 19 trending_up 4

Solved November 19, 2013

I have to download historical end of day data for a huge list of stocks. I found on the bloomberg excel add-in the function…

thumb_up 6 trending_up 7

Solved November 5, 2013

I'm trying to rename the ThisWorkbook code module of an Excel worksheet using VBA Extensibility. I accomplish this with the line…

thumb_up 8 trending_up 7

Solved November 5, 2013

Is there a way to get a list of all valid properties for a given object? If I wanted to start at cell a1,…

thumb_up 9 trending_up 7

Solved October 30, 2013

I'd like to write a table like this: ---------------- | Long Cell | ---------------- | 1 | 2 | ---------------- How to write the…

thumb_up 35 trending_up 17