set

  1. R

    VBA not error in mail merge macro. No Recipient

    I am trying to send a mail merge using VBA. I based it on code I got from this tutorial https://www.youtube.com/watch?v=WoCuRFEuACg&t=289s and then made some changes. When I tested it after changing the subject info, but not the message yet I got an error saying At least one Recipient is...
  2. M

    Paste Values

    Hi Quick question I'm trying to copy a data from one worksheet to another. I can now copy the data the only problem is it has a formula. What im trying to paste is the values only and no longer will copy the formula. Here is my code Sub Button1_Click() Dim source As Worksheet Dim...
  3. M

    Specifying a Worksheet with VBA

    Hi Excel Experts, I am struggling with how to reference a Worksheet in VBA and hope someone can help me. I have a macro enable book where the code opens a different Workbook and copies the first worksheet to the macro book. Once the code has done its thing I need to sort the results. I had...
  4. T

    Greater than / less than when in a table.

    So, I'm pretty much a noob at Excel and this will probably be one of those kinds of questions, but here goes. I have a table with the first two columns being 1 hour increment markers (staggered +1hr), labeled T1 and T2. the next column will be a set of COUNTIFS functions asking if a set of...
  5. S

    Meeting uploader not emailing required attendees

    Hi all, I've found some VBA code that I've catered to my own "Schedule Uploader" using the inputs in the table below to create meeting invites to Microsoft Outlook calendars. My one problem is that the required attendees are not getting the meeting emailed to them, and thus it is not showing up...
  6. K

    VBA and SAP

    Hi all, Although i only recently joined as a member, this forum has been invaluable and often popped up when searching the internet for solutions to problems i have had in the past. Thankyou to the community for all your hard work. I have been working on macro's now between excel and SAP for...
  7. T

    Boolean set first cell check if data then got to next cell

    Hello, I would like to find the code to set a start cell to check if there is a number in it, if not check next cell in the row? Example sometimes the source data is in BL3 and others its BK3. so if I can set a short loop it might solve an issue. ws2.Range("A1").Value = ws1.Range("BL3").Value...
  8. D

    Set Due Date/Time using DateAdd exclude weekend and holiday

    Hello, Need help, i use DateAdd function in my Query, DateAdd("d",numberofdays,StartDate), however i need to exclude the weekend and holidays. Can you guide me on how i can do that. Thanks Regards, Den
  9. M

    VBA Outlook and Word Library - Late Binding help

    Hi Team, Please assist in converting below outlooks and word library code to late binding. Below is attempted Code. Sub Outlook_Late_Binding() Dim OutApp As Object Dim OutMail As Object Dim ProcurementStatusSh As Worksheet Dim WorkStatusSh As Worksheet Dim...
  10. J

    Bookmarks in a word document

    Hi There! I have two columns of data, one that has a list of bookmarks and another with corresponding data in a workbook. I need to write a macro that looks at the data column, assesses to see if it blank. If it is not blank, it needs to look at the bookmark name and put the data into the...
  11. ChuckDrago

    Endless loop in Email macro - OLE action?

    Hi everyone, Need some help with the following macro <code/>Sub Mailer(SendTo, CcTo, Subj, TxtBody) Dim OutApp As Object Dim OutMail As Object On Error Resume Next Application.DisplayAlerts = False ActiveWorkbook.Save Application.DisplayAlerts = True Set OutApp =...
  12. B

    ComboBox Value in VBA

    Hello all, I have the following code below, I want to be able to set some kind of autofilter on the drop down box to show only the given part number of "217230*". I tried including it in the Criteria1: field but did not work. I only want to see the part numbers "217230*" when you click on the...
  13. T

    Random numbers between two values with condition

    Hi all I'm stuck with a mental block here: I want to generate 20 individual random numbers between two values (-3.28 and 14.50) but with a condition that the average of the 20 numbers should equal a set value, in this case 5.61 Can someone help please?
  14. R

    Help making VBA Gmail mail merge code work

    I am adapting some code to make a mail merge work directly from Excel using a Gmail address, but I am having some problems. Any help would certainly be appreciated. I want this to send an email to every column that does not equal "not scheduled this week" in column "I" my info is in the...
  15. M

    Best Way to Clean Up After Running Code

    Curious about the best way to clean-up after running code. I often run code that utilizes Workbook, Worksheet, Range, ADODB.Connection and ADODB.Recordset variables, sometimes all in the same procedure. At the end of the code I set all variables equal to nothing (e.g., Set dbConn = Nothing)...
  16. L

    VBA URLPictureInsert pics disappear

    Hi there, I have VBA to insert images from a filepath which is derived from a formula. The images insert just fine and are visible for me but if someone else opens the documents they cannot be seen (all settings are correct). I'm assuming I need to embed the images but cannot quite get the...
  17. kelly mort

    Ranking Code Amendment With System Reserved Numbers -vba

    I want to set some numbers as system numbers to use against the ranking as done by the code below. Currently, I am using three numbers – 100, 95 and 90. In the future, I may reduce (say 2 numbers) or increase (say 5 or more numbers). And in each scenario, the aim is to make those numbers take...
  18. S

    check for missing records and paste to sheet

    hi all, I have the following code: For iCounter = 9 To iLast Set rng1 = ws.Range("G9:G5000").Find(ws2.Range("G" & iCounter).Value) If rng1 Is Nothing Then ws2.Range("A" & iCounter & ":" & "K" & iCounter).Copy ws.Range("A" & ws.Range("A" &...
  19. Johnny C

    Re-activating XL VBA error after pasting into powerPoint

    I have a utility that copies charts and named ranges into PowerPoint slides. It worked fine until I added some code to (in bold below) resize the copied Shape and move it on the slide. Now it crashes with a Runtime error: 9 Subscript out of range (on the red line below) The DoEvents loops just...
  20. T

    Pasting Formats

    Hi I have the below code which copies a range data from a workbook and it works well. I just want to copy formatting such as borders and font colour etc. I have tried using .PasteSpecial xlPasteValuesAndNumberFormats as per below but it doesn't seem to work. = ws.Range("A1:A13").PasteSpecial...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top