Stack Overflow
Stack Overflow

Questions tagged [excel-2007]

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2007 is the 12th version of Microsoft's commercial spreadsheet program. It is the first version of Excel to incorporate a new user interface (UI), which is now standard across most/all Office suite programs.

This tag is used for questions specific to the 2007 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2007 should be tagged .

Links:

3668 questions
23
votes
4 answers

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*",C1)),"1","") This equation searches for the presence of Gingrich in C1, if it exists, it displays a 1. All I'd like to do is search for more…
Chris J. Vargo
  • 2,266
  • 7
  • 28
  • 43
22
votes
4 answers

How to easily create an Excel UDF with VSTO Add-in project

What I am trying to do is to create User Defined Functions (UDFs) for Excel using VSTO’s C# “Excel 2007 Add-in”-project type (since I just want to generate some general UDFs). As I am only trying to learn the basics (at this stage anyhow) this is…
user118193
22
votes
10 answers

How to resolve "Could not find installable ISAM." error for OLE DB provider "Microsoft.ACE.OLEDB.12.0"

I am trying to import data from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() command with the "Microsoft.ACE.OLEDB.12.0" OLE DB provider, and I'm getting a persistent "Could not find installable ISAM" error. All hardware…
Martin_W
  • 1,582
  • 1
  • 19
  • 24
22
votes
11 answers

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 a web server. I don’t have any problem to fill the values in the sheets; however I am struggling to set the classic Date format in a cell. Below a quick…
Dan
  • 625
  • 2
  • 7
  • 23
22
votes
3 answers

simple vba code gives me run time error 91 object variable or with block not set

So I have a simple little macro/sub defined when a command button is clicked. The problem is it gives me: Run Time Error '91' : Object Variable or With Block not Set My code is: Dim rng As Range rng = Sheet8.Range("A12") '<< ERROR here rng.Value2 =…
gideon
  • 19,329
  • 11
  • 72
  • 113
22
votes
8 answers

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 display only 1-5. I can do this using the following code: My_Range.AutoFilter Field:=1, Criteria1:=Array("1", "2", "3","4","5"), _ …
user4577989
21
votes
3 answers

Declare a variable as Decimal

I'm optimizing a macro in VBA which had none of the data types declared, so everything was clumsily treated by the compiler as a variant. I'm dealing with scientific measurements, so I need precision. How do I declare Dim decAsdf as Decimal (not…
user4974730
21
votes
4 answers

Using QUARTILE in an Excel pivot table to summarise data by sub-populations

I've got a large table of data in an Excel spreadsheet that, essentially, can be considered to be a collection of values for individuals identified as belonging to various subpopulations: IndivID SubPopID Value 1 A 33.56 …
Assad Ebrahim
  • 6,234
  • 8
  • 42
  • 68
20
votes
35 answers

Chart won't update in Excel (2007)

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values The calculated values never change directly, but only as a result of other cells in the sheet changing When I change…
samJL
  • 737
  • 2
  • 11
  • 27
20
votes
10 answers

How to Select all the cells in a worksheet in Excel.Range object of c#?

I am trying to select all the cells in an Excel sheet in the Excel.Range object of C# for applying auto fit, border etc. I have some merged cells within the sheets. Is there any simple trick to do so?
Chethan
  • 360
  • 1
  • 2
  • 15
20
votes
5 answers

excel email validation formula

I have a column where people enter email address manually. I want to validate the email address using this formula: =AND(FIND(“@”,A2),FIND(“.”,A2),ISERROR(FIND(” “,A2))) but excel comes up with error that the formula you typed contains an error.…
Hassan Ata Ullah
  • 347
  • 1
  • 2
  • 16
20
votes
3 answers

Conditional Formatting by Expression using EPPlus

I'm trying to format some range by using conditional Formatting feature of EPPlus. I read many document but there is nowhere mentions about Conditional Formatting Expression. I'm very confusing. Don't know how to use that feature. Here are my some…
Han
  • 3,272
  • 3
  • 24
  • 39
19
votes
8 answers

How to create running total using Excel table structured references?

I'm looking for a way to create a running total (total of the current row and above) using Excel table structured references. I know how to do it using the old row/column based way: =SUM($A$2:$A2) And I know how to total an entire column using…
studgeek
  • 14,272
  • 6
  • 84
  • 96
19
votes
2 answers

What is the character code for new line break in excel

I tried char(10) and char(13) but they don`t work by me. I use Excel 2007 and my task is to replace new lines with intervals
Radoslav Ivanov
  • 209
  • 1
  • 2
  • 3
19
votes
2 answers

VBA: How to delete filtered rows in Excel?

I have an Excel table that contains some data. By using next vba code I'm trying to filter only blank cells in some fields and delete these rows ActiveSheet.Range("$A$1:$I$" & lines).AutoFilter Field:=7, Criteria1:= _ …
mbigun
  • 1,304
  • 4
  • 19
  • 46
1 2
3
…
99 100