excel-vba

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

Solved November 26, 2013

Application.WorksheetFunction.Match method

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 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 26, 2013

I am a VBA newbie, and I am trying to write a function that I can call from Excel cells, that can open a…

thumb_up 16 trending_up 7

Solved October 24, 2013

EDIT: Instead for my solution, use something like For i = 1 To tmpRngSrcMax If rngSrc(i) <> rngDes(i) Then ... Next i It is…

thumb_up 6 trending_up 8

Solved October 4, 2013

I'm trying to open all appropriate PDFs found in the same directory as my Excel workbook using VBA. I've added the Adobe Acrobat xx.x…

thumb_up 14 trending_up 4

Solved October 3, 2013

I am currently trying to make a macro that will go to a directory, open a workbook (there are 38 currently with an eventual…

thumb_up 9 trending_up 6

Solved September 30, 2013

probably could be a rare petition, but here is the issue. I am adapting an excel of a third-party to my organization. The excel…

thumb_up 11 trending_up 3

Solved September 26, 2013

I've been teaching myself Excel VBA over the last two years, and I have the idea that it is sometimes appropriate to dispose of…

thumb_up 22 trending_up 16

Solved September 26, 2013

I am working with cell values in a format of "XXXX-000-000-000". Everything before the first hyphen needs to be removed, which I can do.…

thumb_up 13 trending_up 4