Solved
January 13, 2009
Can a VBA function in Excel return a range?
I seem to be getting a type mismatch error when trying to do something like this: In new workbook: A1 B1 5 4 Function…
thumb_up 36
trending_up 15
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
December 18, 2008
Setting a font color in VBA
I want to set the font color of a cell to a specific RGB value. If I use ActiveCell.Color = RGB(255,255,0) I do get…
thumb_up 7
trending_up 6
Solved
November 17, 2008
How can I lock the first row and first column of a table when scrolling, possibly using JavaScript and CSS?
How can I create a table that has its first row and first column both locked, as in Excel, when you activate 'freeze panes'?…
thumb_up 8
trending_up 24
Solved
November 9, 2008
Excel: ‘Unable to set the Calculation property of the Application class’
I'm trying to automate some stuff in MS Excel. When I try to set the Calculation property I get the following error message: 'Unable…
thumb_up 6
trending_up 7
Solved
October 21, 2008
Insert cell comments in excel programmaticaly
What's the better way to insert cell comments in excel 2007 files programmaticaly using c# and .net 3.5?
thumb_up 6
trending_up 5
Solved
October 10, 2008
How do I protect all worksheet in an Excel workbook with a single click?
I have around 25 worksheets in my workbook (Excel spreadsheet). Is there a way I can protect all the 25 worksheets in single click…
thumb_up 11
trending_up 5
Solved
October 6, 2008
How do I slice an array in Excel VBA?
What function can I use in Excel VBA to slice an array?
thumb_up 31
trending_up 18
Solved
October 4, 2008
What are the differences between using the New keyword and calling CreateObject in Excel VBA?
What criteria should I use to decide whether I write VBA code like this: Set xmlDocument = New MSXML2.DOMDocument or like this: Set xmlDocument…
thumb_up 7
trending_up 6
Solved
October 3, 2008
How do I show an embedded excel file in a WebPage?
I want to allow an Excel report to be viewed embedded in a WebPage... is there a way? I don't want to use an…
thumb_up 7
trending_up 6
Solved
October 1, 2008
How to write an Excel workbook to a MemoryStream in .NET?
How do I write an Excel workbook to a MemoryStream without first saving it to the file system? All options within the Microsoft.Office.Interop.Excel.WorkBook save…
thumb_up 6
trending_up 12