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
I'm creating and formatting excel files and want to wrap the text in column. I found the method in xlsxwriter which is text_wrap() but when I use this method, I
I have 3 combo-boxes and an OK button. I need to set the value of multiple cells in multiple worksheets equal to the value of the combo box selection. Dim choic
I'm building an XLL for Excel, and am trying to register functions via XlfRegister. According to Microsoft's documentation , the target procedure to be invoked
In an Excel formula, is it possible to get a custom document property without an external add-in or help from VBA code?
Scenario I have an excel cell that contains value with leading zereos (Eg: 0002). My macro is copying this value to a variable called runNumber and pasting it i
I have never been so frustrated with Excel in my life. I'm coming up against two major deadlines at work, and the only way to get the right info to the right pe
I have never been so frustrated with Excel in my life. I'm coming up against two major deadlines at work, and the only way to get the right info to the right pe
I'm trying to use a vba if statement to check if my cell H22 on sheet 1 matches a cell in column I on sheet 2. can someone please show me where im going wrong?
I am trying to make kws grouping using excel, but my formula is becoming gigantic. I was wondering if there is an easier way to do what I am trying to accomplis