I am running a experiment in excel using NORM.S.INV(RAND()) Is there a way to set the seed for the random function?
My ultimate goal is to give any piece of information on contacts in Outlook or MS Exchange and get their name and email address without encountering any warning
I am in need of help with looping through a range (In this case Column "C") and finding 5 specific words (Sort, Set, Shine, Standardize, and Sustain) and then o
I have a Value 38142 I need to convert it into date format using python. if use this number in excel and do a right click and format cell at that time the value
I have used Imports Microsoft.Office.Interop and Reference of Microsoft excel is added to project/solution Following are declaration Public xlsfilepath As Stri
I'm trying to simplify a project where, actually, the user specify their own values in two fields (string1 and string2). Then, in another sheet, there is a form
I'm trying to fill a dictionary with name as key, and an array with codename and if sheet is visible. This is where I ran into a conversion issue with sheet.vis
I was reading the Apache poi guide: https://poi.apache.org/spreadsheet/quick-guide.html And I decided to follow along and type the code into my Eclipse project
I have a list of items in a sheet like so: My code goes through each row and groups the supplier and copies some information into a work book for each supplier
I created a macro in Excel where I can mail-merge data from Excel into Word Letter Template and save the individual files in the folder. I have Employee data i
I am trying to create an if-vlookup that retrieves data from 2 sheets with following specs: if the retrieve from the 1st sheet shows N/A and 0 results than vloo
I want to copy a selected range from Excel to the body of an Outlook mail (Office 2013). The table is pasting with Center Align. I want to paste with left-align
I have a number on a spreadsheet which is a combination of many different numbers on a list. For example: A list contains: 100, 200, 250, 500, and 1000 The numb
So say A1 - A8 contain values 11, 120, 321, 435, 623, 765, 964, 1039, B1 Contains a value of 1375 how could use a formula or macro in excel to work out how many
I've got a DLL written in VB.NET that provides Excel plugin capabilities. I'd like to move it into a cloud service. As far as I can tell, there's no way to use
I want to build an Iphone app that can download an Excel file and show the content in a table. I think i managed to download the file but the data i get looks
I'm trying to access an excel file the Apache Workbook module. The code runs perfectly sometimes, but mostly I get an error saying: exception javax.se
Sub Flow_Drop() If ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 1").Value = xlOn And ThisWorkbook.Worksheets(2).CHECKBOXES("Check Box 5").Va
I have an Excel 2010 chart, with several series. I have added data labels to one of the series. I want to change the font size of all labels of that series at o
I have a bunch of values like 0.5, 1.0, 1.5 etc. I want to write a SUM function for those cells but the value is 0. If I use integers the summing works so the