Top "Excel-2013" questions

The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft.

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. …

excel vba runtime-error excel-2013
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. …

vb.net excel ms-access-2013 excel-2013 vba
Using VBA to autofilter Multiple columns, with values from different sheet

I want to use VBA to filter a dump-sheet by 2 columns, with criteria gotten from values on a different sheet …

vba excel excel-2013 autofilter
How to Count number of text instances in excel?

I have a table of my workdays and I want to count instances of word 'work' in each row. I …

excel excel-2013
Calculation with values expressed in different units (KB, MB, GB)

I am looking for a simple way in Excel to calculate with units of different values. I have a list …

excel excel-formula excel-2013 array-formulas
Dynamically call a macro passing parameters from shape OnAction property

Well, my problem is that I have created a VBA Sub that receives an excel Cell reference and 2 text values …

vba excel excel-2013
What does the number in the AddChart2 VBA macro represent?

I've use my Excel 2013 to record a macro in inserting a chart, a column-clustered chart in my case. In the …

excel vba charts excel-2013
Camel case converter in an excel

I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am …

excel excel-formula excel-2013
Excel 2013 Open a file and prompt user with "Author would like you to open as read-only"

I have an excel file. When the file is opened I would like the user to be prompted with the …

excel excel-2013
Add comments to cells using VBA

Is there a way to activate a comment on a cell by hovering over it? I have a range of …

vba excel excel-2013