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 VBA loop through listbox

I have this code that I am using to search a range when I click the item in my listbox. I have never looped through a listbox and want to know how I add a loop to perform what I need without clicking each item in the listbox. Here is the code I am…
Noob2Java
  • 213
  • 1
  • 7
  • 18
1
vote
2 answers

VBA Delete column where first cell is a string of array

I have an excel file in which I would like delete columns that aren't useful. Say I have 4 columns: 'ID', 'Name', 'Surname', 'Job'. What I'm trying to do is delete all columns that aren't 'ID' and 'Job'. I tried using the Range.Find method, but…
DanielMc
  • 139
  • 12
1
vote
1 answer

Excel VBA Add Item below ListBox Selection

I have a ListBox that I am reading a text file into that has several lines. I am currently clicking a line to search for the value clicked in a sheet and then adding that value to the listbox which goes to the bottom. If I have 10 lines in my…
Noob2Java
  • 213
  • 1
  • 7
  • 18
1
vote
1 answer

In Excel, remove duplicates from one column based on the values in another column, either through VBA or a combination of formulas/functions

I'm having trouble trying to achieve this in an accurate and automated way. I've tried the approaches discussed here, here and here, but none work in my scenario. I have a spreadsheet with thousands of rows of data. Data is organised as…
Monomeeth
  • 753
  • 3
  • 13
  • 29
1
vote
1 answer

Timespan Arithmetics to predict tide

I am trying to predict tide in c# using a formula given below: The program was already done in excel, however when translating it to c# I am encountering some problems. This is the formula in excel: =PI()*((C18)/(C19)+1) Cells C18 and C19…
Ahmed Faizan
  • 446
  • 5
  • 12
  • 22
1
vote
1 answer

FillDown method failing in Excel 2010

I'm getting an error message related to the below VBA Macro in Excel 2010. Purpose of the Macro: I have a Table in an Excel worksheet that is refreshed via an SQL query. the table contains 1 week per column of data, as well as, a few columns…
ubiquetous
  • 31
  • 5
1
vote
0 answers

How to sort multiple pivot tables in a way that rows with similar names displays together?`

I am having 4 pivot tables displayed as below. Pivot Tables Organization I would like to sort each of them in a way that the rows with similar names displays together. Buddy Subscription Buddy Subscription Buddy Subscription Buddy…
Chintan Vadgama
  • 45
  • 1
  • 6
1
vote
1 answer

VBA to Save As with .xls extension with .xlsx features without error

In order for workbooks to be submitted into a special processing program I am using, the file extension must be .xls. If the workbook has special formatting that is only native to the .xlsx format such as special formatting and such and I just…
Robby
  • 843
  • 3
  • 19
  • 53
1
vote
3 answers

Extract unique distinct list from two columns

So I am trying to create a combined list from two separate columns by omitting the duplicate items. I have searched and found a formula that combines the list this way by going through one column at a time. But I want to combine the columns like…
J. Baker
  • 53
  • 1
  • 7
1
vote
1 answer

VBA - InterSect, filtered rows, CTRL+D

I'm handling Change event in Excel using intersect like this: Sub Worksheet_Change(ByVal Target As Range) Dim WatchRange As Range Dim IntersectRange As Range Set WatchRange = Range("B2:B65536") Set IntersectRange = Intersect(Target,…
gaffcz
  • 3,469
  • 14
  • 68
  • 108
1
vote
2 answers

VBA - Excel - Save As and delete original workbook

From a Personal.xlsb file, I want VBA to save the current active workbook as a user-definable name in the same directory and delete the original workbook. Below is my code. It has two problems. One, it saves the workbook in My Documents folder for…
Robby
  • 843
  • 3
  • 19
  • 53
1
vote
0 answers

PowerPivot table relationship not working, repeating totals

Longtime answer-seeker, first time question-asker here so I'm open to feedback about how I'm asking as well. I'm relatively new to Excel's PowerPivot but feel like I have a handle on it for the most part. I am using PowerPivot for Excel 2010. I have…
R Dean
  • 11
  • 1
  • 3
1
vote
1 answer

Is it possible to have a inputbox require 5 digits?

I am currently designing a macro that will require 3 inputs from a user, I want to know if I could somehow require the numeric inputs to require a 5 digit serial number. And restrict anything that is more or less then five digits. This is my code so…
Charlie West
  • 61
  • 2
  • 12
1
vote
1 answer

Excel 2010 If cell matches any part of string in list

I'm looking for a formula that can search a given list of strings and match a certain cell based on whether that cell contains text that appears in any part of a string from the list. An example to show what I want to achieve: Reference_List: …
sl133
  • 1,339
  • 2
  • 15
  • 28
1
vote
2 answers

Excel: Passing the current cell as argument when calling vba function from worksheet

I'm trying to make a VBA function that accepts a cell as argument and works from there using a variety of Range.Offset. This function will be called in the worksheet cells. For testing I'm using this simple script: Public Function…
Raestloz
  • 203
  • 1
  • 4
  • 10
1 2 3
…
99 100