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 can't make this work. I've tried everything! .EntireRow.Delete has so far only worked when i used .Select to choose cell 33,2 but due to wha
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 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
I have a routing sequence for a set of machines on an assembly line. Each route has to go through the entire line (that is, if you only run the first and second
I made a PQ append query, send reults to Data Model and then uploaded the pivot table to the excel sheet. Now I'm trying to apply filter based on the cell value
I am getting a Runtime error 1004 and when I debug it, it takes me to this sub, this sub works fine in another sheet, I don't know whats wrong, can anyone help?
I am trying to automate file upload on chrome, getting error here :method run object iwshshell3 failed" please help: Dim Customer_rates As String Dim WshShell
I'm trying to add a toolbar control on a sheet. I get this error. It does add the toolbar, but that error is not skippable with On Error Resume Next, so it stop
I achieved resolving Names with this code from an example: Function MailSuchen(strSuchen As String) Dim objEmpfaenger As Outlook.Recipient Dim objExchBe
I have several signatures in html format. I need to choose one of the signatures according to the domain included in To: and CC: label. The code below merges t
I am using this code: Function wrksht() as Variant wrksht = Application.Caller.Parent.Name End function I am continuously being thrown run time error '424' ob
Is it really not possible to declare a 0-length array in VBA? If I try this: Dim lStringArr(-1) As String I get a compile error saying range has no values. I
I would like to restrict emails which have recipients outside our organization using my domain. Is there a way to restrict emails using NOT LIKE condition? I am