I have Excel VBA code that imports Outlook mail data from one folder into Excel. I change this for three folders all at the same level (not subfolders). Is ther
I am trying to use an if else statement to delete the entire row when a text value is found in a cell within a given range. The code stops after deleting one ro
I would like to convert the number of digits in excel into respective words as shown in the picture above. How can I achieve this functionali
I was using regularly a macro add-in in excel which stopped working all of a sudden. I get several error messages in the following order when I launch the macro
I'm trying to export all sheets in the workbook as separate pdf files using one button. I followed a YouTube tutorial: https://www.youtube.com/watch?v=FRZ6n3gHt
I am trying to extract a picture from a Word document and save it in a file, using vba. I don't really care about the output format, as long as it is readable.
I am trying to convert data from rows with different lengths into two columns. The value of the first column remains equal to first cell of the row and is copie
I created a macro for Excel which opens a list of all visible sheets in a workbook and goes to the desired sheet as you scroll through the list. The idea is to
I got a VBA project from colleague who is retired. I have to change a function: Documents.Add Template:= _ "c:\word\Link.dot", _ NewTemplate:=False, Doc
How do I copy/paste multiple ranges? The code returns the cell A1. What I need: 1- Search and open all Excel files in a folder with subfolders 2- Copy specific
I am wondering how I can call a public subroutine that resides within a userform of two option buttons. Specifically if that user selections optionbutton1 from
I am wondering how I can call a public subroutine that resides within a userform of two option buttons. Specifically if that user selections optionbutton1 from
In the sub workbook_open I'm opening 4 workbooks in the background to be able to have references to them without having them "open". (they are not visible) But
I am attempting to load rows in an Excel worksheet, "List of Golfers", from worksheet "Players". On the Players worksheet I have a table named "GolfTrip". On th
I’m running Excel 2010 & Excel 2003 on a Windows 10 version 21H2 machine. I noticed a change in the appearance of Rob Bovey’s VbaCodeCleaner. A
I'm trying to print an area of a page to pdf. I select the range but when I try to set the print area I get: Run-time error '1004': Unable to set the print are
In VBA I am trying to create a sumifs formula with multiple criteria across different workbooks, but I am struggling on the syntax. WorkbookRecut.Worksheets("Su
I've been looking for different approaches to fix my problem, whether it's with vlookup, index, index /match but couldn't figure it out yet. I'm trying to list
I want to rename mergefields in a Word document. I use the following script (based on Change value of Word MailMerge field using VBA). I run the script and I se
I wrongly assigned colUMN variable, then changed to colN but VBA has started to act all Column method with colUMN. When I use intellisense it is written as Colu
amazon-s3