Top "Excel-2010" questions

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft.

macro - open all files in a folder

I want to open all files in a specified folder and have the following code Sub OpenFiles() Dim MyFolder As …

excel excel-2010 vba
Ignore cells on Excel line graph

I am trying to draw a line graph in Excel 2010. The y column data source has some gaps in it …

excel excel-2010 linegraph
VBA error 1004 - select method of range class failed

First time poster, so if there is any formatting, or guidelines I failed to adhere to, please let me know …

vb.net excel excel-2010 powerpoint vba
How to easily get network path to the file you are working on?

In Excel 2003 there used to be a command that I added to my toolbar that was called Address (if I …

excel filepath excel-2010
Excel: the Incredible Shrinking and Expanding Controls

Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time. …

excel vba excel-2010 excel-2007 excel-2003
VBScript - How to make program wait until process has finished?

I have a problem in a VBScript that I am using with a VBA/Excel macro and a HTA. The …

vba vbscript excel excel-2010
Excel VBA Run-time Error '32809' - Trying to Understand it

A colleague at work made some changes to one of our macro workbooks and now on my PC only I …

excel excel-2010 vba
How to select clear table contents without destroying the table?

I have a vba function in excel 2010 that I built using help from people on here. This function copies the …

excel excel-2010 vba
Return Max Value of range that is determined by an Index & Match lookup

I need a cell to display the max value of a range who's row is defined by an index and …

excel excel-formula max excel-2010 excel-match
In excel how do I reference the current row but a specific column?

Let's say I had the datasheet A B C D ----------- 5 4 6 3 4 4 3 2 5 4 6 2 And I wanted to do something like A B …

excel excel-formula excel-2010