Solved
February 18, 2013
How to find a value in an excel column by vba code Cells.Find
I have to find a value celda in an Excel sheet. I was using this vba code to find it: Set cell = Cells.Find(What:=celda,…
thumb_up 26
trending_up 20
excel-vba
136 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
February 13, 2013
How to add a DocumentProperty to CustomDocumentProperties in Excel?
I'm trying to add a DocumentProperty to the CustomDocumentProperties collection. Code as follows: Sub testcustdocprop() Dim docprops As DocumentProperties Dim docprop As…
thumb_up 6
trending_up 5
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
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 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
How To Display Part of Excel on VBA Form
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