excel-2013 Questions
3
I need help with a tool I have created for my office team to monitor their effort utilization using Excel 2013 VBA Macro.
Unfortunately, the Macro could not find Add-Ins in anyone else's system tha...
Serriform asked 7/11, 2017 at 12:9
4
Solved
Right now I have a long list of "Industry" values that users have submitted through a form. I've written a macro that will search for particular terms in those values and paste values that conform ...
Inevasible asked 23/11, 2015 at 21:27
5
Solved
I have a workbook to do 'smart'-graphs on my expenses. It's been running for a year and there are now a lot of graphs and expenses. Excel now throws an out-of-resources error whenever I change anyt...
Prase asked 10/3, 2013 at 23:53
6
Solved
I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am using this formula to do that
=LEFT(A1) & RIGHT(SUBSTITUTE(PROPER(A1),"_",""), LEN( SUBSTITUTE(A1,"_",""))-...
Shrunken asked 14/11, 2017 at 13:49
3
Solved
I use Excel 2013 and Power View and SQL Server 2008 R2.
After create my Data Source and my chart in Excel When I want save my Excel file I get this message
be careful parts of your document may i...
Couch asked 21/1, 2014 at 10:34
5
Is there a way to activate a comment on a cell by hovering over it? I have a range of cells that I would like to pull respective comments from another sheet when hovered over each individual cell. ...
Dextrous asked 9/8, 2017 at 21:9
7
Solved
When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 %.
I want to apply % format on a column but want to keep the values same as...
Lifework asked 29/5, 2013 at 6:23
10
Solved
I'm showing a custom task pane in an excel VSTO add-in, I'm building it and showing it as thus:
var ctrl = new CellTaskPane();
var pane = CustomTaskPanes.Add(ctrl, "Custom Sheet");
pane.DockPositi...
Wyoming asked 4/7, 2014 at 15:50
2
I have list A with 259 items and list B with 626 items. There is some overlap between the list, so I want to find all items on list B, which are not on list A. I've been trying to find some info on...
Sanyu asked 27/3, 2016 at 11:40
2
Solved
I know that I can use conditional compilation in VBA to differentiate between the 64bit and the 32bit version (using #If VBA7 Then ...).
Is there also a build in constant similar to Application.Ve...
Mccray asked 29/1, 2013 at 10:39
4
I've use my Excel 2013 to record a macro in inserting a chart, a column-clustered chart in my case. In the view code option, it shows me a line of code as below:
ActiveSheet.Shapes.Addchart2(286,x...
Slovakia asked 11/1, 2015 at 16:50
3
Solved
I'm trying to remove duplicates in excel 2013 VBA. but I'm getting error "object does not support this property or method". The problem is I don't have static range to select. I want remove duplica...
Parallelepiped asked 25/7, 2015 at 21:17
9
I have searched the excel function documentation and general MSDN search but have been unable to find a way to return the sheet name without VBA.
Is there a way to get the sheet name in an excel f...
Graphophone asked 1/2, 2015 at 17:27
6
Solved
I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel. I made sure it worked on both Excel 2010 and Excel 2013 for PC. I then tried to use this same program on Exc...
Halda asked 30/6, 2014 at 19:57
5
Solved
I am attempting to write some VBA which will add header text to 3 cells then fill a formula all the way down to the last row. I have written the below, which writes the headers no problems, b...
Disrespectful asked 23/3, 2017 at 22:14
6
Solved
No matter what I try, Excel 2013 continues to run in the background on Windows 10 no matter what commands I throw at the end of my PowerShell script. I've tried adding all suggestions I've found to...
Orange asked 19/8, 2016 at 17:46
4
Solved
I am not sure if this is the right place to ask this question but I am facing an issue with MySQL installed failing to recognize office 2013 and install MySQL for Excel.
Basically MySQL
https://de...
Attah asked 7/2, 2013 at 23:32
5
Solved
I need a pseudo random number generator for 2D Monte Carlo simulation that doesn't have the characteristic hyperplanes that you get with simple LCGs. I tested the random number generator Rnd() in E...
Natal asked 11/8, 2016 at 8:30
4
In my code, I have declared these variables:
Dim Field_Name, Datatype, row As Integer
Then, inside a For loop, I have this code:
Field_Name = Worksheets(i).UsedRange.Find("Field Name").C...
Odor asked 29/3, 2014 at 18:29
2
Solved
I have a spreadsheet with 250+ rows of data and need to find the largest value in each row. I tried to use Conditional Formatting, however I need the same rule for each row so can't highlight all t...
Goldfilled asked 27/11, 2015 at 17:7
4
Solved
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, i...
Kohima asked 10/2, 2013 at 23:36
3
Solved
In Excel 2013 how can I change options (or is it possible) to always allow native DB Queries?
Can someone walk me through how to set this up?
Keyte asked 12/5, 2016 at 12:8
4
Solved
How can I find the last row in a range of cells that hold a formula, where the result of the formula is an actual value and not empty?
Say in a simplified way that the range of cells ("E1:E10") h...
Izanagi asked 28/11, 2015 at 12:18
6
Solved
I'm looking for a way to apply a color scale to a set of cells via VBA code but not by applying some conditional formatting... I want to apply them as static colors (InteriorColor)
I've searched p...
Minstrel asked 29/1, 2015 at 14:33
4
I'm working on a macro for a friend of mine who needs to import a set of images in an excel document and later use this document on other computers. The problem I encountered is that when opening t...
Matriarch asked 11/11, 2013 at 14:17
1 Next >
© 2022 - 2025 — McMap. All rights reserved.