Top "Excel-2010" questions

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

Delete entire row if cell contains the string X

I am new to VBA and I am trying to come up with a way to delete all rows (and …

excel vba excel-2010 excel-2007
Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns …

excel excel-2007 excel-formula excel-2010 vba
Freezing Row 1 and Column A at the same time

I want to "freeze" Row 1 and Column A simultaneously in Excel 2010. Is this possible?

excel excel-2010
How to use workbook.saveas with automatic Overwrite

In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" Application.DisplayAlerts = False Set …

excel vba excel-2010
filter out multiple criteria using excel vba

I have 8 variables in column A, 1,2,3,4,5 and A, B, C. My aim is to filter out A, B, C and …

excel vba excel-2010 excel-2007
What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Using Microsoft Excel 2010, I noticed two kind of controls that can be inserted into a document: Form Controls and ActiveX …

excel vba excel-2010 activex form-control
Closing a Userform with Unload Me doesn't work

I need to close an Excel userform using VBA when a user has clicked a submit button and operations have …

vba excel excel-2010
How to delete Certain Characters in a excel 2010 cell

In column A I have a load of name that look like this [John Smith] I still want them in …

excel character excel-2010 cell
Get list of Excel files in a folder using VBA

I need to get the names of all the Excel files in a folder and then make changes to each …

vba excel excel-2010
Excel: Searching for multiple terms in a cell

I use this handy equation to search for a term inside of a cell in excel. =IF(ISNUMBER(SEARCH("*Gingrich*",…

excel excel-2007 excel-formula excel-2010 excel-2013