Excel VBA

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

Solved February 11, 2013

VBA Excel, mismatch for inputbox as integer

My code Dim a As Integer a = InputBox("Enter the number", "Program", "", 7000, 6000) If a = Empty Then ' do code... Else…

thumb_up 9 trending_up 8

Solved February 6, 2013

Is there a way for DIR(path) in VBA to handle strings longer than 260?

Given the following snippet: Dim s As String: s = "S:vicbla[..insert more here..]data.xml" Debug.Print Len(s) Debug.Print Dir(s) If Len(s) >= 260 I receive an…

thumb_up 6 trending_up 9

Solved January 17, 2013

Setting a chart source data based on a variable cell range in VBA

I am creating a report template part of which will be generating data charts with a structure similar to a moving average for this…

thumb_up 10 trending_up 4

Solved January 10, 2013

Find all references to a cell

I have the following data ----------------------------------- . A B C 1 Data Total Left 2 D1 10 5 3 D2 20 13 4 D3…

thumb_up 24 trending_up 11

Solved January 7, 2013

TRUE and FALSE don’t work within SUM()

I have boolean values in a column: A 1 TRUE 2 FALSE 3 TRUE 4 TRUE I realize that in Excel =TRUE+TRUE returns 2…

thumb_up 10 trending_up 10

Solved December 27, 2012

Excel SUMIF between dates

I have column A with date values formatted as mm/dd/yyyy. I am trying to sum the values of column B if A >=DATE(2012,1,1) AND…

thumb_up 29 trending_up 17

Solved December 21, 2012

Excel VBA Loop on columns

when we are going to do a loop in the rows, we can use code like the following: i = 1 Do Range("E" &…

thumb_up 13 trending_up 5

Solved December 16, 2012

Why doesn’t an Excel/VBA user defined default property that returns a Range behave like a Range?

A property in an Excel/VBA class I'm writing returns a Range. I made it the default property for the class using the technique described…

thumb_up 4 trending_up 8

Solved December 7, 2012

Deselect all items in a pivot table using vba

Can some quicly explain the way to deselect all items in a newly created pivot table so that I can go back and select…

thumb_up 6 trending_up 5

Solved December 7, 2012

Range[] instead of get_Range()

http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.get_range.aspx it says to use the Range property instead of get_Range(Object Cell1, Object Cell2).…

thumb_up 5 trending_up 7