Stack Overflow
Stack Overflow

Questions tagged [excel-2013]

The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula then tag it Excel-Formula.

Excel 2013 is the 15th version of Microsoft's commercial spreadsheet program. Microsoft has significantly enhanced the charting and Business Intelligence capabilities in this new release.

This tag is used for questions specific to the 2013 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 . Questions about addins for Excel 2013 should be tagged .

Links:

1745 questions
3
votes
2 answers

Align Excel cell to center VB - xlCenter is not declared

Im using Visual Studio 2013 Visual Basic, MS ACCESS 2013, EXCEL 2013 My program Save As the data in my datagrid to excel. I use access 2013 as my database Here is my code: Imports System.Data.OleDb Imports Excel =…
zerenin
  • 77
  • 1
  • 2
  • 8
3
votes
2 answers

Excel VBA URL hyperlink in RichText email body

Does anyone know how to create a RichText email body, that has a URL bookmark in it? For example, here is my code: Sub SendEmailUsingWord() Dim olApp As Outlook.Application Dim olEmail As Outlook.MailItem Dim olInsp As Outlook.Inspector Dim wdDoc…
Dave
  • 51
  • 1
  • 4
3
votes
1 answer

Pair columns A and B, get the matching data in C considering doubled values for different users

I have columns "Manifestos A" and "Manifestos B" (with its correspondent "volumes"). "A" has more than 1000 lines and "B" around 800, so its impossible doing by hand. Column "Manifestos C" must have the results of "A" > "B" matching and pairing, and…
Human_AfterAll
  • 231
  • 3
  • 12
3
votes
2 answers

Putting an Excel UDF into the Worksheet object (as opposed to in a module)

I suspect the answer is "not possible" - but there is no harm in asking this fine community! I have a Excel 2013 UDF (User Defined Function) that is unique to a certain worksheet. Currently, I have this UDF in a "Module" in the containing Workbook.…
Nic
  • 88
  • 5
3
votes
3 answers

Excel.Application.Cells.SpecialCells(xlCellTypeLastCell) returning bottom of worksheet, not last data cell

I'm writing a method in VBA in Excel 2013 to loop through the rows in two worksheets and compare the text in a column from each. When I run my code, I find that the code loops through the entire worksheet, not just the rows with…
DarkMoon
  • 1,169
  • 3
  • 9
  • 16
3
votes
1 answer

Is there any way to force Excel 2013 to open files within the same window instance?

Is there any way to force Excel 2013 to open files within the same window instance? I am extremely disappointed that Microsoft is forcing it's users to open multiple instances for every workbook they open. Why on earth would they take away this…
EnergyGeek
  • 271
  • 1
  • 4
  • 14
3
votes
2 answers

How to type Unicode currency character in Visual Basic Editor

There is a project requirement where we need to check a cell for its currency type. I came across a similar question in this forum (How to check if cell is formatted as Currency?). It explains how to do that for the $ symbol. But I couldn't replace…
Kannan
  • 31
  • 1
  • 3
3
votes
4 answers

Find all values greater or equal than a certain value

Let's say I have the following table. Team Score AA 81 BB 67 CC 44 DD 1.5 JJ 279 LL 49 TT 201 GG 158 MM 32 HH 89 I want to get all teams that scored more than 80 in another table. I tried the Index + Match function as follows…
Quester
  • 1,969
  • 4
  • 15
  • 13
3
votes
2 answers

Hiding Rows in Inactive Sheets in Excel 2013

Switching to Excel 2013 from Excel 2010, When Sheet2 is inactive The code Worksheets("Sheet2").Rows("432:432").EntireRow.Hidden = False gives Error Unable to set the Hidden property of the Range class But works fine when Sheet2 is the Active…
Shorn Jacob
  • 1,183
  • 5
  • 22
  • 38
3
votes
1 answer

Change excel default cursor to arrow pointer

I am developing a application on excel 2013 using vba, I want the user of application always see arrow pointer instead of excel default cursor (plus [+] looking cursor). I know there is a following method: Application.Cursor = xlDefault But this is…
RedLeo
  • 127
  • 3
  • 10
3
votes
1 answer

Excel--SUMPRODUCTIF? Work around?

I am trying to calculate how many class registrations my company has received per month, per year. ] So far, I've been able to do this using SUMPRODUCT, (for example: =SUMPRODUCT(--(DATE(YEAR($A$2:$A$10),MONTH($A$2:$A$10),1)=DATE(2013,1,1)))) but…
MCarte35
  • 31
  • 1
3
votes
1 answer

Excel 2013 VBA Web Query connection string containing variable

I am getting a Run-time error'1004' error on the following line. With ActiveSheet.QueryTables.add(Connection:=connstring, Destination:=Range("$b$2")) Destination:=Range("$b$1")) The Variable connstring seems to be causing the problem. How do I…
user3200885
  • 31
  • 1
  • 2
3
votes
1 answer

Copy PasteSpecial in For Each loop quits irregularly

I have a routine to copy hidden backup formulas for a selection that has worked fine in Excel 2003/2007/2010. When I run it in 2013, it starts to work through the selection and then just quits, no error message is given. When testing just this…
user3158939
  • 33
  • 3
3
votes
1 answer

Filling column with formula with no variable

I'm struggling with a problem here. I'm sure it's so simples, that's why I can't find the answer. I need to apply this to Sheet1!C4:C22: =(RANDBETWEEN(1.45*100,1.95*100)/100)+Sheet2!C12 Problem is: I've tried Fill tool && select the range…
user2823183
  • 77
  • 8
3
votes
5 answers

Filter all unique items like Google Docs

Is there a quick/easy way to filter all unique items in an Excel 2013 column similar to the Google Docs "Unique" function?
Mike Fitzgibbons
  • 45
  • 2
  • 3
1 2 3
…
99 100