Only for questions on programming against Excel objects or files, or complex formula development.
I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a …
excel vba passwordsI would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note …
excel if-statement excel-2010 worksheet-functionI'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "…
.net excel aceoledbI wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And …
excel vba scope global-variablesHow can I use regular expressions in Excel and take advantage of Excel's powerful grid-like setup for data manipulation? In-cell …
regex excel vbaIf I select a cell containing a formula, I know I can drag the little box in the right-hand corner …
excel excel-formulaHow do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and …
excel excel-formula excel-2010This seems like a simple Pivot Table to learn with. I would like to do a count of unique values …
excel excel-formula pivot-tableHow do I return a result from a function? For example: Public Function test() As Integer return 1 End Function This …
excel vba function return return-value