back

  1. S

    VBA EMail distribution not working

    Hello, I've built a program in excel VBA that creates emails and attaches invoices based on a distribution list. The program creates drafts of the email and saves them for review before we manually send them. The issue is that every single e-mail came back undeliverable. This is the e-mail I...
  2. L

    Rearrange Data

    Hi, I have data in this format: <colgroup><col><col><col><col></colgroup><tbody> CID "C-00001" "C-00002" "C-00003" Name Alexandra Van de Vyvere Nathalie Pouradier Duteil Thomas Raguenaud Waist 75 79 88 Half Waist Front 39 40 Half Waist Back 37 39 Hips 92 98 104 Half Hips Front...
  3. S

    Randomly generated list with duplicates in column

    Hello, My apologies if this has been asked before. I read through several threads and can't seem to find exactly what I need. Basically, in column A, there is a list of locations in groups of two that the names in column B are assigned to in pairs. The list in column B is larger than the...
  4. M

    Index Match Not Working

    Hello. I have done this a thousand times before (well maybe hundreds) w/o issue. However, for some reason I can get anything to return on the following: =INDEX('Flood Report'!$X$2:$X$15000,MATCH($A22,'Flood Report'!$AN$2:$AN$15000,0)) If I do a CountIf('Flood Report'!$AN$2:$AN$15000,$A22)...
  5. R

    [VBA] Automation Error - no context, no error code, nothing.

    Hi all, Workflow below ALL Code resides in sheet "Super Automation" Information is gathered on "Ads" tab and brought into "adstemp" Advert Data is opened and relevant tours gathered Advert Data closed, tourlist is loaded into Automation Hub Several spreadsheets are now opened (Regional Press...
  6. H

    Prevent editing/deleting of named cell ranges without worksheet protection, and...

    That's it really. I don't want to be having to use passwords to protect a sheet in any way so want to use just VBA. I have to apply this to N5:N5000 so that no one can edit, delete, cut, remove the formula that is in there. I did find great code for this once but it was years ago and I can't...
  7. B

    Loan repayment calculation

    Hi I want to take out a loan for 25,000,000 at 7% annual fixed interest rate and make month end monthly repayments. I want to take out the loan immediately "month 0" but not start paying it back until month 7... because I won't have any income for 6 months. I must pay the whole lot back by...
  8. R

    VBA - This is causing my code to loop and I can't stop it

    NoTours:Resume Skip Skip: ads.Activate ActiveCell.Offset(1, 0).Activate WB.Save For some reason after I hit WB.Save, it goes back to "NoTours" and just goes over and over. Do I need to insert something after the WB.Save to stop it returning to NoTours? Thanks.
  9. R

    Sum up to A3 automatically

    In column G I need to see the SUM of column D from the row i'm currently on up to row 3 is there a way to write a formula that when i copy it down it automatically expands the sum cells? so if i'm in G20 it sums D20 all the way back to D3 and then if i drag that formula down it automatically...
  10. redspanna

    IF formual based on two criteria with a minus figure

    I have simple table below that will work out return and place into E1 if a W is placed into C1 Back Odds W/L Formula Result 15.00 2.5 W =IF(C1,"W",A1*B1 37.50 how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure...
  11. C

    Back End Only Opening Read Only

    So this has happened now 2 days in a row -- I administer an Access DB with 12-15 users -- each user has an .accde copy of the front end on their desktop and the back end is on a shared server. I got a call saying that all of a sudden nobody could add a new entry to the db. I look into it...
  12. S

    Formula Help

    Hi everyone, I would like to find a formula that will calculate how may cells back when a digit appeared. For example, A1 = 2 B1 = 2 C1 = 2 2-2-2 9-7-0 8-1-3 1-4-3 7-3-5 9-2-9 6-6-8 2-0-7 1-4-8 7-7-2 Step1: Count how many cells back until the 1st digit 2. In this example the 1st 2 is 5...
  13. S

    Phantom tab overlay

    Hello, I have a spreadsheet that's giving me a very strange issue. Sometimes when I paste special values, or change a number being used in a calculation, I get a partial overlay from a different tab on top of my current tab. Here is a screenshot showing the issue: https://imgur.com/a/YG1mfUF...
  14. E

    Is it possible to use RegEx in Search and Replace?

    Hello I want to use back references and regex with Search and Replace, is it possible? Thanks!
  15. P

    Index Match - bring back 2nd match

    I am trying setup an index match but I have 2 of the same value. How can I setup my index match to bring back the second match? thanks
  16. S

    Workaround for numbers as text

    Hi, We export data into a workbook, all of the product codes are 4 digits but they are in text format. When i go to do lookups they dont work unless I paste the product codes into notepad and then back into word again. So 2 questions here I suppose: 1. Is there an easier way to do this rather...
  17. L

    find date in past based on dates day number the show show cell value in same row

    Results to show in columns F,G and H. Please if possible don't use VB scripts I would like excel to look at the days number in column A (7/6/2018 = 6), then go back that many days (including the day). For example: In Column A, If today is the 6th, then go back 6th,5th,4th,3rd,2nd, to the 1st...
  18. shg

    Default import/export path

    When I import or export modules from the VBE, my default path was where I wanted it until this past week when I somehow hosed it, and now I have to navigate to get back to it each time I restart Excel (it remains stable in each session). Does anyone know how to change the default path...
  19. M

    solution for forgotten password to unprotect sheets.

    Hi everyone. Seven years ago I wrote a large workbook as a favour for a friend. I protected a lot of cells to avoid accidental corruption. He has just come back to me and asked for some changes. I gave him the password but as hes never needed it he's forgotten it and my email storage doesn't go...
  20. G

    Embedded Vlookup problem

    Hi, I'm trying to use a Vlookup to use different ranges within an existing Vlookup depending on what's in column B. =VLOOKUP(A2,VLOOKUP(B2,StaticData!$A$2:$X$21,24,FALSE),2,FALSE) I'm getting an #value because the range is coming back with speech marks around it... Any help appreciated...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top