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
I've the following macros working independently of each other (sort of). I need them working together. First I import data from a URL that points to a CSV file
I am working on a project to do the following. Data I get from ERP: After running the code it should look like: I want to implement this logic If there is a v
I have this timesheet and based on a day in the row (F8:AJ8) I want its whole column to highlight with yellow (Color index = 44) if it = "Fri" and change their
I have the following code in an Excel VBA module that looks up the ProjID named cell on the worksheet, selects columns needed for output from dbo_Proj_Dash Acce
I am using the Save method of the Search object that is returned by the advancedSearch method to create a Search Folder. As I have multiple accounts in my Outlo
I want to give glow/shrink animation to a text in PowerPoint using VBA. I can not configure it to give size 110% (it takes default size 150%) & also want a
I want to give glow/shrink animation to a text in PowerPoint using VBA. I can not configure it to give size 110% (it takes default size 150%) & also want a
It was known that UserInterfaceOnly:=True setting was not saved with the workbook. So every time a Wb was opened, the Worksheet.Protect method had to be used wi
I would like to save a mail body and header just as if it were printed by Outlook or PDFCreator. The sender, cc, bcc , time, to, subject are data that must be i
I looked through a few posts but it didn't help. My code merges same emails into one email and also consolidates a table. Works if I were to send to all. Sub Se