jonas sværke

Hi all, I currently have a macro that saves my sheet as a PDF, however when I try to do this, it brings me this error: If I debug it highlights this in my VBA code: The code is this: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As String Path = "R:Path\PDF files\"...

Hi all! I currently have this setup (albeit with more columns in reality): I would like to sort it by dates first, and then by the number after. However, I want this done, so it respects the date assortment before the number assortment, so it wouldnt for example put: 1 - February: 1 Before...

Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...

Hi all, I have the following setup (albeit in a much larger setting with multiple lines of emails): I want to merge my emails in A121 and A122 into one cell, like I have done above in A120. Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...

Hi all, I have the following formula: The formula checks if the value in column D is located anywhere in sheet 2's values in the array B1:D133. However, when I pull the formula down, it also checks blank cells. Is there any way to edit this formula, so when it checks a blank cell (for...

Hi all, I have this formula I found online: I have now set the formula to test if my value "test" in cell B2 is located anywhere at all in within the value set B1:D133 in sheet 2. I literally have the value "test" in cell B2, but it does not work: It should return the value "1" if the...

Hi all, I currently have this setup: My VBA code is this ( credits to @RoryA :) ) Option Explicit Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...

Hi all, I have this amazing email macro that @RoryA helped me build (big credits!). He created a nice loop for me that runs all subjects in an email meaning I can email as many email addresses as I want at a time. However, when I run it now, it converts my text into numbers for some reason...

Hi all, I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error: and debug highlights this: Did I not do it correctly? What do I need to fix? Thank you all! BR. Jyggalag