VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
4
votes
0answers
304 views
Excel Error 406 when using both VBA and ActiveX addins.
My Excel addin (XLL AddIn, call it MyAddIn) is built with C#, ExcelDNA, NetOffice, VS2010. Client has another addin (let's call it B), I guess it is written in VBA.
Client says B works fine without ...
3
votes
0answers
48 views
Programmatically control/intercept a Data Table refresh
Background
I have an extremely large data table that takes up to 12 hours to run for around 1 Million input scenarios on a high-end 64bit machine
To improve the process I am looking to test and ...
3
votes
0answers
103 views
Spinning 3D chart in powerpoint presentaiton
I created a macro in Excel that will spin a 3D chart. I copied the chart into PowerPoint, set up the code to run in PowerPoint when the slide is shown. The code runs, but I cannot get it to actually ...
3
votes
0answers
543 views
Look up Column number in a range?
I'm trying to use the filter option to filter my range.
ActiveSheet.Range("$K$2:$ZZ$200").AutoFilter Field:=11, Criteria1:="yes"
Basically that will filter Column U for yes.
What I have is a ...
3
votes
0answers
715 views
Excel VSTO fails to load if there's VBA macros
I have an excel XLS developed with Visual Studio Tools For Office (VSTO) 2005. Most of the code is in C# VSTO, but there is also a VBA macro to implement a worksheet function. I'm not trying to have ...
2
votes
0answers
40 views
Subscript out of range error (Error 9): .FormatConditions
My code sometimes throws up an Error 9, Subscript out of range error. Amongst many other things, my code takes a load of cells and removes existing conditional formatting to them and then re-applies ...
2
votes
0answers
43 views
How to highlight a cell when formula result from another sheet changes?
This is one that's been killing me and I've tried almost every solution on the Internet.
Here's background. I have an HR model that has each department broken out on separate tabs. I want to run an ...
2
votes
0answers
10 views
Get source range for a PivotItem
A PivotTable allows you to "drill down" into a set of data by double-clicking on a value, or by right-clicking on a field and selecting "show details":
My question is, are there any methods in VBA ...
2
votes
0answers
25 views
Data validation lost when I copy a worksheet to another workbook
I have an Excel 2010 workbook that contains a number(18) of worksheets. I have one sheet named "Data" that contains a number of named ranges that I use in data validation lists on the main worksheet ...
2
votes
0answers
38 views
Is there a way to get the returned URL from a 301 redirect using VBA exclusively?
I have a long list of our company's product numbers, and later in the code these numbers have to be converted to HTML and then linked to the product's corresponding page. The links to the pages have ...
2
votes
0answers
27 views
Excel: Using Point mode in a UserForm
I noticed that using a RefEdit control causes Excel to go into "Point" mode for selecting the appropriate range. (You see the "Ready" status change to "Point" and the current reference becomes ...
2
votes
0answers
56 views
Excel VBA: Listbox Error when assigning Linked Cell
I have some cells with Data Validation. Because the dropdown list is small and hard to read, I have a button which opens a list box and populates it with the cell's Data Validation list.
Dim ...
2
votes
0answers
791 views
VBA Excel: How are Collection Keys Used?
I implemented a collection of class objects. I got the instructions for how to create the collection of class objects from an online article, but I don't totally understand it. My collection works. ...
2
votes
0answers
424 views
VBA HTML format is lost when message is sent to non-outlook client
I have a macro that parses a spreadsheet and compiles emails based on parsed data. The problem that I'm facing is the visual formatting.
When I use the macro to send the email to an outlook email ...
2
votes
0answers
342 views
AutoFilter Criteria Using Array (Error) - Too Large String?
Update: Through some additional testing I discovered:
1) 255 Characters does seem to be the breaking point (character limit). Setting the filter with an array with a character length of 245 worked ...
