error

  1. D

    Run-time error "53": File not found - How to fix?

    Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...
  2. M

    Need help with macro

    Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...
  3. C

    Excel VBA Errors when trying to copy and paste objects from Excel to Word

    Hello All, I have some VBA code that I need help refining. The problem I am having is inconsistent and unexplained errors, from my research it appears that the issue is with the clipboard crashing. How the VBA code works: I have an embedded Word documents with various bookmarks and reference...
  4. A

    VBA Error?

    Hi, I have the following VBA code: Set Wbk1 = ActiveWorkbook Fname = "Path name" Set Wbk2 = Workbooks.Open(Fname) Wbk2.RefreshAll DoEvents Wbk2.Sheets(1).Copy , Wbk1.Sheets(Wbk1.Sheets.Count) Wbk2.Close False So basically this code is part of a macro that opens ANOTHER...
  5. D

    (Fast read!) Send out email automatically with attachment through command button

    Hello everybody, Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...
  6. A

    VBA work on my computer and not on others with the same version

    Hello, I have a macro on my computer that works perfectly but it does not work on 2 others computers, but not the same lines... I tested on a colleague (1) computer (Excel for office 365 MSO - 32 bits) Some line at the very end of the macro has an error With the macro I am creating a word...
  7. Y

    Formula Error - Don't Know What the Error Is

    I found some information/formulas on a website and I tried to transfer the information to my own spreadsheet so that I could play around with other stock/exercise prices and dates. I am trying to get the formulas listed below for D1 (cell B12), Call Price (B16), and Put Price (B17) to work out...
  8. G

    Delete rows if (certain value) exists in data set.

    Hello, I've been trying to delete rows in my data set that contain the following keyword "lename" This is the following script I found and the following error Script : Sub Delete_All_Rows_IF_Cell_Contains_Certain_String_Text() Dim lRow As Long Dim iCntr As Long lRow = 150000...
  9. S

    Occasional runtime 1004 error

    Hi Folks, I'm running the below code...and it works fine...some of the time. Other times I get a runtime error but I can't figure out how to resolve it; any tips? The bit where I get an error is; For Each shp In ActiveSheet.Shapes If Not Intersect(Range(shp.TopLeftCell...
  10. B

    Last row in Dynamic Range

    I am attempting to retrieve the value found in the last cell/row in column E of a dynamic range. The first row containing data will always be E12 and the last row fluctuates on a daily basis. The formula I am using invariably returns the value found in E12 only - so I am obviously doing...
  11. S

    Run-time error '1004

    Hello Experts: I have a rather irritating problem that does not make sense to me and I am hoping that someone can help please. I have some code that: Creates a list of files to be opened Opens each file in the list and scrapes some specific data from each file opened if present Places the...
  12. S

    IFERROR formula

    Hi, Im working on a warehouse database with orders and quotes I have this IF formula =IF($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote)) But its giving me a $REF in all cells. This is because the cells reference too, Data is not in the cell., Im trying to do a IFERROR so that when...
  13. M

    "run-time error '-2147417848 (80010108)" - Selection.Insert Shift:=xlDown - Please Help!

    I have created a template for my work and the below Macro sometimes works, but sometimes crashes with the code "run-time error '-2147417848 (80010108)" When I go to debug, the highlighted section is Selection.Insert Shift:=xlDown - I cannot see an issue with this to be honest so any help would...
  14. K

    Macro-assigned button causes error

    I have a code that generates two new sheets based off of templates every time that it runs. I have a button that the macro is assigned to. When I click the button, it generates the first of the two sheets and then gives me an error 400 message. I go back, delete the sheet that was generated, and...
  15. J

    Error Handling Help

    I have what is probably a simple error handling issue for most of you but I can't seem to figure it out. I have an excel userform with multiple text boxes that auto populate via a vlookup. This all works fine except for one text box I can't seem to get the error handling right for. I need a...
  16. K

    Formatting help

    Hi, I have this problem with my excel in general: above sum should be 0. All decimals are exactly 2. Is there something i can correct in the formatting in my excel? Thank you in advance for your help.
  17. S

    Syntax errors

    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: Syntax Error: Function TotalAdder(RCell As Range) 'Begins Error Handling Code On Error GoTo Helper Dim xIndex As Long Application.Volatile xIndex = RCell.Worksheet.Index nsheet = Left(Tname...
  18. S

    Workbook Closing closes other open workbooks

    I have the code below in a workbook. When I close the workbook, it typically kills all other open workbooks of excel. However, excel has started opening a blank window (no loaded workbook) in a second window whenever opening any excel file. Anybody have ideas on both of these. Further, sometimes...
  19. B

    Power Query - Combine, transform and track data

    Hello All, As a reasonably seasoned excel user, im embarking on learning power query to try to achieve something which could quite well be impossible :) So hoping I can get some clarification from the real experts! Situation: I have a CSV file provided to me every day detailing a list of...
  20. W

    Runtime Error 13 in my code

    I am getting a run time error 13 in my code between the **. Can anyone out there see why? For some reason the code will run and do what I want, but then spit out the error. Any help will be appreciated. Sub Recon() Dim i As Integer finalrow =...

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