I've been learning all the nifty tools I have to debug in the VBA editor for excel, but I can't figure out if there's a way to have watches st
I have a macro that can send multiple mails with attachments to an specific user, this had no problem when I sent 1 file to 1 user, but I modified it so it loop
Using an Excel formula, I'm trying to pull the MAX value for a NAME that has a certain LETTER next to it. Eg: Highest # for a specific % for each unique Name
I used code from the following article https://docs.microsoft.com/en-us/office/vba/api/excel.range.copy to partially accomplish my goal but I have a few more qu
I have an xml file which I am trying to import into excel but the most important column being imported has 18 digits and excel only allows up to 15 digits. I
i am trying to send emails through excel and keep the email signature i am able to either save .body as text withough the image or insert the image through .HTM
I added a UserForm into my file so comments can be added to a cell (that way I can update the data on other cells when a comment is added and someone is mention
I am using this code to convert rows to individual text files. Sub SaveWorksheet() Dim MyWorkbook As Workbook Dim MyDataWorksheet As Worksheet Set MyWorkbook =
I get a Type Mismatch Error "13" with the below code. Can anyone assist with where I'm going wrong with my VBA syntax and use of variables. If Applicat
I have a macro that intermittently throws a run-time error when doing a PasteSpecial. Most times it runs through to completion without failing, but sometimes i
Im currently using this. while this works for now. Im looking to add code that allows me replace everything in that column. Not just limited to only replacing t
I have earth flow displacements in two directions, converted to point data, which I am trying to combine for an overall offset direction (point to where the flo
I have tried searching on SO, and certainly have not found solution for similar problems, may be I haven't used the right word to search. So, Column A & Col
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),
I'm still reasonably new to VBA and I'm trying my best to learn, but this one has stumped me. I have a Userform where one of the textboxes is for a user to ente
I want to find mail in the olFolderSentMail folder, using the domains of the email addresses, with VBA. When I make an advanced filter in Outlook, the result co
What I am trying to achieve is as follows, I have "Workbook A" and "Workbook B", within Workbook B there is a worksheet "SheetB2" which I would like to be inclu
I'm attempting to calculate periods of out of stock for a fleet of rental equipment that has been in service for the past few years. I'm having trouble creating
I have 2 columns I am trying to populate in my sheet using vlookup. One column is the buy amount and one is the sell amount. I am using 1 unique ID to lookup in
I can't figure out how to prompt the user for a folder path and the save name. Below is the code I have gotten to work. Sub PrintToPDF ThisWorkbook.Sheets("Sh