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
34
votes
9 answers

How to call VBA function from Excel cells (2010)?

I defined a few functions in a workbook using VBA, and then expected to be able to use them in a cell formula - but Excel does not recognise the function. I just get #NAME? Tried: Realising I had created an XSLX file, I converted it to a XSLM file.…
Mark Bertenshaw
  • 5,594
  • 2
  • 27
  • 40
33
votes
3 answers

Setting all Excel sheets at a defined zoom level

I have more than twenty sheets in an Excel workbook (file). Is there some code snippet or a command I could apply/use so that all sheets could be reset to let's say 85% zoom level?
Regmi
  • 2,658
  • 4
  • 24
  • 32
31
votes
11 answers

How do you select the entire excel sheet with Range using VBA?

I found a similar solution to this question in c# How to Select all the cells in a worksheet in Excel.Range object of c#? What is the process to do this in VBA? I select data normally by using "ctrl+shift over arrow, down arrow" to select an entire…
C. Tewalt
  • 2,271
  • 2
  • 30
  • 49
31
votes
3 answers

What exactly is the function of Application.CutCopyMode property in Excel

Well first of all I found couple of answers while googling but most of the forums are blocked in my Office Network hence asking this question here! One more intention is to get an answer in plain English :P I understand if we set…
Saikat
  • 14,222
  • 20
  • 104
  • 125
30
votes
4 answers

Excel formula to remove space between words in a cell

I've a huge data in excel file. For eg: say i've a word like paul son,i've to make it as paulson. input:paul son output:paulson. In some cells ,i've data like mic-li,when this type of words come,it should not replace any thing,it should only remove…
user1180001
28
votes
6 answers

Copy an entire worksheet to a new worksheet in Excel 2010

I have found similar questions that deal with copying an entire worksheet in one workbook and pasting it to another workbook, but I am interested in simply copying an entire worksheet and pasting it to a new worksheet -- in the same workbook. I'm…
user567677
27
votes
2 answers

Edit SQL in Power Query

When I import data from Sql Server in Power Query, I can paste a query to be executed against the database. But later when I want to edit this query in Workbook Queries > Edit > Advanced Editor, I get something like this: let Source =…
AdamL
  • 12,421
  • 5
  • 50
  • 74
26
votes
5 answers

Setting seed for Excel random number generator

In excel below formula will generate random number from a normal distribution with mean 10 and variance 1. Is there a way to set a fix seed so that i get a fix set of random numbers all the time? I am using Excel 2010 =NORMINV(RAND(),10,1)
user2543622
  • 5,760
  • 25
  • 91
  • 159
25
votes
3 answers

Excel error 1004 "Unable to get .... property of WorksheetFunction class" appearing inconsistently

I have a VBA function within a spreadsheet which operates on another spreadsheet that is opened in an earlier stage of my macro. The macro used to work fine but just recently has started causing a 1004 error ("Unable to get RoundDown property of…
Neil
  • 686
  • 1
  • 9
  • 27
24
votes
4 answers

Closing a Userform with Unload Me doesn't work

I need to close an Excel userform using VBA when a user has clicked a submit button and operations have been carried out. How can I close a Userform from itself? I have tried this but it returns a 361 error. Unload Me
Kian
  • 1,260
  • 1
  • 13
  • 32
24
votes
2 answers

How does one restore default case to a variable in VBA (Excel 2010)?

At some point I accidentally named a variable range (all lower-case) and since then the Visual Basic for Applications editor refuses to use Range (Pascal-cased); it will auto-correct it to lower-case. How can I reset its "brain" to forget about my…
Neil C. Obremski
  • 18,696
  • 24
  • 83
  • 112
23
votes
6 answers

Excel 2010: how to use autocomplete in validation list

I'm using a large validation list on which a couple of vlookup() functions depend. This list is getting larger and larger. Is there a way to type the first letters of the list item I'm looking for, instead of manually scrolling down the list…
Pieter
  • 647
  • 4
  • 9
  • 16
23
votes
4 answers

Removing special characters VBA Excel

I'm using VBA to read some titles and then copy that information to a PowerPoint presentation. The problem is that the titles have special characters, but image files that I am also coping over do not. The title forms part of a path to load a JPEG…
pixie
  • 283
  • 2
  • 3
  • 10
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
3 answers

Converting HTML to Excel?

How to convert HTML template to Excel file
Saicharan S M
  • 828
  • 3
  • 11
  • 25
1
2
3
…
99 100