Top "Excel-2007" questions

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

Why am I getting Error 2042 in VBA Match?

I have Column A: +--+--------+ | | A | +--+--------+ | 1|123456 | |--+--------+ | 2|Order_No| |--+--------+ | 3| 7 | +--+--------+ Now if I …

excel excel-2007 vba
What is causing "Automation error Unspecified error" on Worksheet_Activate?

I have a worksheet named "Dates" (object name is A_Dates) that needs to be calculated when it is activated (…

vba error-handling excel-2007
VBA Macro across multiple worksheets

I am trying to run a single macro which performs functions on multiple worksheets. Let's say I have assigned the …

vba excel excel-2007
Excel VBA get range of user selected range by mouse

This is not the usedrange issue. For example in Excel user selects a range (possibly empty) using mouse, let's say …

vba excel excel-2007 excel-2003
How to get combobox not to accept user input in Excel-Vba?

Does anyone know what the properties are in the combobox that I can manipulate in order not to allow the …

excel vba controls excel-2007
Excel (2007) VBA - .Formula with quotes in it

I tried putting the following code into a program yesterday. VBA called an error. I assume it is because of …

excel excel-2007 vba
How to check whether certain sheets exist or not in Excel-VBA?

Does anyone know how to check whether certain sheets exist or not in an Excel document using Excel VBA?

excel vba excel-2007
OpenXml and Date format in Excel cell

I am trying to create an Excel file in xlsx format using OpenXML because I need to use that on …

c# excel-2007 openxml
Deleting pictures with Excel VBA

How do I delete all the pictures in an Excel 2007 worksheet? A working code example would be great.

vba excel-2007
How to programmatically code an 'undo' function in Excel-Vba?

Is there anyway to code an undo function onto a CommandButton similar to the Excel's very own undo function? Or …

excel excel-2007 vba