Stack Overflow
Stack Overflow

Questions tagged [excel-2010]

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft. 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 2010 is the 14th version of Microsoft's commercial spreadsheet program. Microsoft made slight user interface (UI) changes; otherwise, it continues to use the UI pioneered in Office 2007.

Features such as Sparklines and Slicers were introduced in Excel 2010 to provide more charting and data visualization power.

This tag is used for questions specific to the 2010 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 2010 should be tagged .

Links:

6168 questions
1
vote
1 answer

Excel 2010: Automatically combine multiple tables into one dataset

I thought there would be a simple way of doing this, but unfortunately I have not come across one. My company has an Excel workbook with 12 sheets (1 for each month), into which I enter sales data as accounts are written. I reformatted each month's…
Jkoug
  • 11
  • 2
1
vote
1 answer

Select all non-blank cells and associated Rows

I've been searching for well over 3 hours for a formula or vba solution for this and for some reason can not find anything. I need something to look at a column, find all the non-blank cells, and output them elsewhere. Here is a small example table…
bonzo
  • 312
  • 2
  • 4
  • 19
1
vote
1 answer

VBA Return Cell Value from a Named Cell in a Closed Workbook

I am trying to retrieve a cell value from another workbook without opening the source file. The below will return the value from "SourceRange" when I use the actual cell address. However, I want to modify the below code to reference the cell name…
nam24
  • 51
  • 9
1
vote
4 answers

VBA compile Error: unexpected error 35010

I am trying to compile a big project in Excel however the unexpected error is showing up often but not always. One engineer told me that it is related to virtual memory. Can anyone please tell what should I do to eliminate this issue? Thank you!
Yucheng Guo
  • 75
  • 1
  • 7
1
vote
0 answers

Max/Min a named range thats offset excel

So I'm wondering how to find the min/max of a named range based on the value in another column. Col A Col B Col C S_1 x x max = S_2 y x min = S_3 y y max = S_4 x y min =…
bakeson
  • 91
  • 1
  • 2
  • 9
1
vote
1 answer

Workbooks.Open Compile Error

I am trying to use the Workbooks.Open Method within Microsoft Excel VBA 2010 and I am receiving a Compile error stating that it is expecting "=". Have I mistyped the code? Workbooks.Open ( _ Filename:= FromBook, _ UpdateLinks:=…
TroyPilewski
  • 359
  • 8
  • 27
1
vote
1 answer

How to stop Excel from changing referenced cell range

My formula in Sheet 1, A3 is =SUMPRODUCT(('count May'!$D$2:$D$2000=Categories!$A$5)*('count May'!$E$2:$E$2000=Categories!$B$3)*(ISNUMBER(SEARCH('count May'!$F$2:$F$2000,Categories!$C$4)))) Count may is the sheet for the month of may(I'm doing this…
Ben
  • 27
  • 8
1
vote
1 answer

Excel find next match in table column

I am trying to find the next matching row in a table (not just a range) that matches the current cell's value. I have tried to pass in the column from the next row to the end of the column but cannot get it to work. All ideas are welcome! …
David Austin
  • 37
  • 1
  • 9
1
vote
1 answer

Parsing currency value in Excel VBA

Ok... I guess my brain has finally gone on vacation without me today. I have extracted 2 fields from a website and I get this string vData = "Amount Owed [EXTRACT]$125.00[EXTRACT] vData was declared as an array (string). I split vData on…
Shaves
  • 884
  • 5
  • 16
  • 46
1
vote
0 answers

Excel adds equal sign to SOME lines

I have a .csv file that I generated with a program. And when I open it with Excel. Some lines get an equal sign '=' added in front of them, which causes the excel file to write #NAME? in the cell. But some don't... Some of the lines: these lines +P…
Dueldogg
  • 73
  • 1
  • 4
1
vote
1 answer

VBA Excel - .Window doesnt recognise open excel windows

The code below loops through the open excel files if the file name is what the naming convention is close to it will then run the code in the if statment so that the file can be saved later on This code works in excel 2003 but not in excel 2010,…
Mr.Burns
  • 690
  • 1
  • 10
  • 24
1
vote
1 answer

Excel - Format Date Value to Text

I am having dates in my excel sheet 2013. I need to convert them to TEXT. So when I go to Format Cells & select TEXT option, then the value changes to something else. For e.g If i have date as 01/01/2016, when i change it to TEXT the value becomes…
Anup
  • 9,396
  • 16
  • 74
  • 138
1
vote
1 answer

VBA Convert from text to excel Format cells change from General to numeric for some rows

I have code which compares two folders (textFiles & ExcelFiles), to find if all textFiles are converted to Excel. If not, it calls a function that does this. Everything works well, but when I open the Excel file, the format may change from a row to…
BKChedlia
  • 327
  • 2
  • 4
  • 18
1
vote
0 answers

Request for Efficiency tips

I would like to make clear that the code I am posting works! The request I have is, I would like to make this code more efficient. I am still new to VBA although I am getting better :) The code is below: Private Sub CommandButton4_Click() Dim…
Rumble1701a
  • 23
  • 4
1
vote
2 answers

How do I keep a running tally in excel using a formula?

I am currently working on a project for work and need to have a counter/tally based on the number inputted in another cell, but I want that number to be retained and added to each time that number is changed. (e.g. User enters 2 into cell E7, that…
ItalianStallion4215
  • 139
  • 2
  • 11
1 2 3
…
99
100