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
0 answers

using VBA excel to search on list of names on a website

I have an excel sheet contains list of names which I want to search on specific web page and get their results into cell . I used the below code to open webpage but I can not figure out the correct code to click on log on button "I wrote the source…
ahmed samir
  • 25
  • 5
1
vote
1 answer

Adding Next Month Programmatically (VBA) to a Dynamic Range Table in Excel

I have a dynamic ranged table [Defined Table Name = MainTable]. I also have code which allows me to find the last cell in DateRange (Defined Name Range for Column A). Sub Last_Row_Range() Dim nextMonth As Range Set nextMonth =…
Jeremy Scott
  • 167
  • 1
  • 3
  • 15
1
vote
1 answer

Excel: How to format a column graph so that it automatically adds new columns when new data is added?

A bit of background: I have a table which by using a combination of vlookup and index, goes through my main dataset and pulls out each row of data for a given month (in this case March). Each month will have a maximum of 15 entries, but may have…
BJJ BA
  • 127
  • 1
  • 8
1
vote
1 answer

Excel Sparklines not exported to PDF when using COM Automation

I am having a problem programmatically exporting Excel sheets that contain sparklines to PDF format. When I manually export the Excel sheet to PDF format using Excel 2010's native PDF Exporting facility then everything works fine, but the moment I…
Jeroen Ritmeijer
  • 2,772
  • 3
  • 24
  • 31
1
vote
2 answers

Values from Range not passed to array in a UDF

The following function I wrote returns "" whenever I attempt to use it on ranges that contain formulas. Oddly, when I test what values are returned for rngPhrase and rngTextBlocks in the immediate window, it returns a correct result. I can get a…
rohrl77
  • 3,277
  • 11
  • 47
  • 73
1
vote
1 answer

Excel Reference error due to summing cells

I think I broke Excel. I've downloaded this Template to make a budget, but I'm customising it. I've added a few more rows to one of the tables (Gifts and ...) and I had to re-add the 'Total Row' (and option on the Table Tools, Design -> Table Style…
AncientSwordRage
  • 7,086
  • 19
  • 90
  • 173
1
vote
2 answers

Excel modify macro for "data from text" to open dialog box?

So I work with CSV files and I need to open excel go to Data -> From text and format certain columns certain ways. I recorded a macro that does that but it always opens the file I used when recording the macro. How do I modify the macro so it opens…
Tony Georgiev
  • 23
  • 2
1
vote
0 answers

How to download an excel on the fly using Flask

I'm working with Python 3. Here is the part that sets up the response for file download - import io import pandas as pd @app.route('/download_log',methods=['GET']) def download_log(): output = io.BytesIO() writer = pd.ExcelWriter(output,…
Savvy
  • 547
  • 5
  • 12
1
vote
1 answer

How do I make this formula support multiple rows/dragging?

Continuation of this thread Formula so far. Match[n] = match criteria, HEADER = header criteria etc. This formula Sums the values of the header cells that match a specific criteria, ie: 6502, with this formula, could match a header /6502, then take…
Avan
  • 223
  • 3
  • 13
1
vote
0 answers

VB Excel 2010 application.quit() leaves an EXCEL.EXE process open if the workbook is shared

I have a problem, where a network located shared Excel 2010 file is opened and being edited from VB.net successfully, but when I close it with Excel.Application.Quit(), the window itself closes, but an EXCEL.EXE process remains open. As a workaround…
Zsombor Kiss
  • 11
  • 2
1
vote
1 answer

excel web query properties from drop-down online

I am trying to retrieve data from http://www.professorpaddle.com/rivers/riverlist.asp which automatically defaults to Washington state as the state id. However, I want to pull data from the table for Oregon. Can this be done as a property? So far…
whitewaterfanatic
  • 13
  • 2
1
vote
1 answer

UserForm Close button fails after form launched for second time

I have a UserForm, A, with a command button that opens UserForm B using the below code: Private Sub cmd_click() Me.Hide B.Show End Sub B, when closed via the X button, runs the following: Private Sub UserForm_Terminate() Unload Me …
TehJake
  • 121
  • 9
1
vote
3 answers

counting multiple instances of a number in a range

I have a range of numbers and I need to identify if the first number of each cell is repeated anywhere in the corresponding row. For example, in row 2 below, column 2 and column 3 both start with a 3. I know that if I do =LEFT(TRIM(cell)) to get…
amwakatsuki
  • 49
  • 7
1
vote
0 answers

Auto filter more than 2 or 3 Criteria

Please help me out In the below code where I am trying to use more than 2 or 3 Criteria in Auto filter VBA code. ActiveSheet.Range("$A$1:$AH$122460").AutoFilter Field:=34, _ Criteria1:="<>#N/A", Operator:=xlOr, Criteria2:="<>*n*", _ Operator:=xlOr,…
sagar
  • 397
  • 10
  • 25
1
vote
3 answers

Excel VBA Looping through cells and replacing their values

I am trying to build a macro that cycles through a column of cells and replaces a two letter country code in that cell with the name of that country. However I get an object not found error when I try to run the macro. Sub ChangeCountryText() ' '…
Andrew Lauer Barinov
  • 5,694
  • 10
  • 59
  • 83
1 2 3
…
99 100