Category "vba"

Use VBA to @-Mentions a user in a Threaded Comment in excel

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 have to convert excel rows into individual text files and the text files should be UTF-8 encoded

I am using this code to convert rows to individual text files. Sub SaveWorksheet() Dim MyWorkbook As Workbook Dim MyDataWorksheet As Worksheet Set MyWorkbook =

Excel VBA code error type mismatch using worksheetfunction to find duplicates

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

Intermittent "Run-time error '1004' PasteSpecial method of Range class failed

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

Excel macro to insert certain characters into column

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

Can't figure out how to make ".EntireRow.Delete" delete a Cell in another worksheet [closed]

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

How to use an entry in a vba textbox as the "Link Location" within the hyperlink formula?

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

Searching olFolderSentMail by domain of email address with VBA

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

Mirror worksheet between two workbooks

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

Export to PDF and Prompt User for Folder Path and File Name to Save

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

Shortest Flow Layout Solver

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

VBA "Error 1004: unable to get the PivotFields property of the PivotTable class "

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

Runtime error 1004 Application defined or object defined error

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?

method run object iwshshell3 failed vba

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

Add toolbar to sheet

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

Get primary SMTP mail from department in Outlook addressbook

I achieved resolving Names with this code from an example: Function MailSuchen(strSuchen As String) Dim objEmpfaenger As Outlook.Recipient Dim objExchBe

How to choose the signature automaticaly?

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

How to copy the sheet name to a column on the same sheet?

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

Declare a 0-Length String Array in VBA - Impossible?

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

DASL query to restrict tp emails which have recipients outside our organization

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