vblf

Hello all! I have a series of cells I need to work on and separate the contents based on criteria. The common characteristic marking the point where I need to separate text is two commas followed by a hard return. How can I format the search criteria so it looks for ",," plus the hard return...

I am using vba code to populate the body of an email. In this line [& "Invoicing with Mercury - https://vimeo.com/274171345 " & vbLf _] How do I convert this [https://vimeo.com/27417145] into a url [link]?

When i try to resize a range after offsetting it I get an Application-Defined or Object-Defined Error. Can't understand why. Sub test() Dim sourceSht As Worksheet Dim targetSht As Worksheet Dim LastRow As Long Dim selectedData As Range Set sourceSht =...

Morning all Is there a way that when data is been added to a Userform Textbox and Return is pressed to start a new line that ";" is added to the end of the previous line? The reason i am asking is the data being added are multiple email addresses and when these are added to the new email via...

Hi, I have a textbox where whenever I click to write an email, the cursor shows up below the word "regards", but I want the cursor to show up in between the words "regards" and "Dear Sir". Here's a screenshot of the textbox: [/URL][/IMG] Here is the code that I used as well: _Subject =...

hello all, i have been searching quite some time for this but have not found a VBA script that meets my needs. hoping you can help. I am looking to have a button at the top of my sheet when clicked, will search col. F in sheet8 for any duplicates. If duplicate entries are found it will display...

Hi Guys and Gals, I have a file with some VBA that work brilliantly for me. However, I need to move the location of it, currently sitting on the desktop, b ut when I move it, I get an error in the VBA. Sub PDFTOEMAIL() Dim olApp As Object Sheet1.Unprotect Password:="" Path =...

Hi, Everybody I want to make my Excel comments occupy as little space as possible, since my worksheet may contain so many. So, I remove the User Name in all comments if they were created using "Insert Comment" I also want to remove all spaces represented by vbLf (if user hits Enter)...

Is it possible to specify a font and size and maybe color for only one line? 'sig ssig = vbLf _ & vbLf _ & vbLf _ & sname _ ' would like to specify font and size and color here only & vbLf _ & ttl _ & vbLf _ & " Division" _ & vbLf _ & "8120 Way" _ &...

New to VBA and trying to embed code in control button, but instead of getting data in correct format so that I can apply lookup formulas, it appears it's just generating circular references with no changes to my source data. HELP Here is the code I'm using: Private Sub CommandButton1_Click()...

Hi, I have put together a code which will search between 2 dates in the workbook and then copy and paste the result into a new worksheet but when I run the search it keeps telling me no results were found when I know I have got data in the workbook that meets the dates that I put into the...

Hello, I have a User Form with a DatePicker. I want to Add validation so that only future workdays can be selected (excluding both weekends and Holidays). Date Picker name = DTPickerLaunch Validation occurs on command: Private Sub CommandButtonContinue_Click() List of Holidays is located...

Hi, I have been struggling with this - I have a macro which works well but I want the ability to change the SUBJECT line for each email I send. Can I point this to a cell (column A) so that a unique name is noted on the subject header of each email. In essence the macro runs through a list of...

Hi all, I'm quite new(bie) on writing XML files, so i'm hearing here to see if anyone can help (teach) me some tricks. I have following code to write a "basic file". It is to transfer vehicle data to the authorities in Germany, therefore there is some German in it. Point is, I do NOT want to...

Hi, I have created a file which emails to a list of people, however I am having problems with the cc part of the macro code. I need to "cc" to 3 or 4 people but I am struggling with this. I have specified the "cc" list in cell A1 and A2. How can I "cc" to more than person? Thanks in...

Hi all, I have a code that automatically drafts an email when a cell in range changes to "Closed Won", but would like it to also respond to "Closed Lost". Any ideas how to make it work? Code below, appreciate your suggestions. Private Sub Worksheet_Change(ByVal Target As Range) Dim...

I found this code to make it so a cell with multi lines to easy be the format, but I am trying to incorporate to view it as accounting as the other cell that has single lines that have accounting format. I tried to do it as formatcurrency but it does not look the ones below or above. Can this be...

I am struggling to understand how at times, not all the time, when I press the button to send an email with a PDF of the sheet required, it deletes the active textbox of the sheet. It is not all the time. Can anyone share some help on this? This is the vba code I am using: Sub...

Hi, I have been struggling with this and would be grateful for any suggestions. I have an email macro which runs down a list of recipients in column B and attaches a specified file in column C (saved to my desktop). This operates fine however the recipients have asked for one email with...

Hello, Rick provided me with this VBA code which works great! Sub ID_RiskLevel3_LegalObl() Dim R As Long, X As Long, Z As Long, LastRow As Long, MaxNewRows As Long Dim MaxCol2 As Long, MaxCol3 As Long, ID As String Dim Data As Variant, Result As Variant, RL3 As Variant, LO As Variant...