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
4
votes
2 answers

Public vs Private/Dim in Excel VBA

I could use some help in understanding using Public vs Dim in a module in Excel 2013 VBA. First I want to say I did find this great post with excellent definitions (see link below), but no examples and I could use some examples of how I could apply…
Zack E
  • 696
  • 7
  • 23
4
votes
2 answers

File Save Dialog In Excel VBA

I am trying to follow the tutorial here http://software-solutions-online.com/excel-vba-save-file-dialog-getsaveasfilename/ and have typed up my code to be: varResult = Application.GetSaveAsFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx") Now…
IcyPopTarts
  • 494
  • 1
  • 12
  • 25
4
votes
4 answers

TextJoin UDF For Excel 2013

I am trying to utilize a UDF version of TextJoin since I am using Excel 2013 - but this function is not properly returning the accurate data. My data-set in Excel looks like this saleID Item 5 PRE2323 6 Pre2323223 6 …
Smith Stanley
  • 461
  • 1
  • 8
  • 25
4
votes
1 answer

Find and replace all instances of a pattern in a string using Regular Expressions

Using Excel VBA, I'm trying to replace all instances of a simple pattern that looks like this: {some text} with some other constant string. So I want to find all the text that is enclosed in curly braces and replace is (with the curly braces) with…
EBH
  • 10,350
  • 3
  • 34
  • 59
4
votes
2 answers

Conditional formatting using the INDIRECT function fails with boolean AND or OR or with cells containing formulas

I have the following function for checking whether column L contains the word "completed" and I use INDIRECT to be able to color the whole row with Conditional Formatting: =INDIRECT("l"&ROW())="completed" This function works. However, I need to…
Abel
  • 56,041
  • 24
  • 146
  • 247
4
votes
2 answers

Get First And Last Day Of Year

In VBA I know you can use this syntax to subtract a year from a date Dim testdate As String, DateTest As String testdate= "03/21/2017" DateTest = Month(testdate) & "/" & Day(testdate) & "/" & Year(testdate) - 1 But how could you find the first and…
IcyPopTarts
  • 494
  • 1
  • 12
  • 25
4
votes
1 answer

How to make excel formulae more readable?

I'm looking to make a bunch of my complicated formulas more readable. For example: I know about Alt+Enter to add newlines within the formula itself. This makes the formula a little bit more manageable, but it's still not as readable as I'd like it.…
Taelsin
  • 1,030
  • 12
  • 24
4
votes
1 answer

write.csv with encoding UTF8

I am using Windows7 Home Premium and R Studio 0.99.896. I have a csv file containing a column with text in several different languages eg english, european, korean, simplified chinese, traditional chinese, greek, japanese etc. I read it into R…
Sunday
  • 89
  • 2
  • 2
  • 5
4
votes
2 answers

Why do I get run-time error -2147417848 (80010108) in excel 2013 most of the time I run UserForm?

Task: I work in Excel2013. I tried to write in VBA a userform to add parameters into dynamic named ranges. All named ranges are held in one sheet and were created using insert>table. I select the range, show existing values and get the new value.…
Daniil Koshelyuk
  • 51
  • 1
  • 1
  • 5
4
votes
1 answer

Invalidate Ribbon Control Without Module-Level Variables

I've developed an Excel add-in that includes a custom ribbon. I'd like to be able to invalidate (enable/disable) a control on the ribbon in certain situations, but every example I can find uses a module-level or global variable to store the ribbon…
ARich
  • 3,230
  • 5
  • 30
  • 56
4
votes
2 answers

Add new table from external source using existing connection

I have an Excel 2013 workbook where I have created multiple tabs with each tab showing the results from a different view from an external database. I did this by clicking on DATA->OTHER DATA SOURCES where I then setup a connection and selected all…
user3165854
  • 1,505
  • 8
  • 48
  • 100
4
votes
2 answers

Extracting R-square from Chart into cell

I have an Excel scatter chart, that has a trendline and R2 value. How can I return the R-squared value of the trendline to a variable? I thought: x = ActiveChart.SeriesCollection(1).Trendlines(1).Datalabel.Value but this doesn't work. I know we…
meetesh goyal
  • 71
  • 1
  • 4
4
votes
2 answers

How to find max and min date in a range of another sheet?

I am writing VBA code to find the minimum and maximum dates in a Range. When I execute it, I get an error: Run-time error '1004': Application-defined or object-oriented error. Below is my code: Sub GenerateSheet() Dim i, r, numAssignments As…
Manish Jain
  • 65
  • 1
  • 6
4
votes
2 answers

Trust access to the VBA project object model greyed out

I'm on MS office 2013. I need to uncheck the "Trust access to the VBA project object model" check box for some testing purpose. But I'm unable to do so, as it is greyed out (and it is checked). What might be the reason. How can I enable the check…
Brahmaprasad R
  • 131
  • 2
  • 9
4
votes
2 answers

VBA Centre Userform On Active Screen

I wonder whether someone can help me please. I'm using the 'Extract' code below which runs on the click of a button, which also, as you may be able to see, initalises a 'Splash' form with a scrolling progress bar. Private Sub btnFetchFiles_Click() …
IRHM
  • 1,326
  • 11
  • 77
  • 130
1 2 3
…
99 100