debugging

  1. S

    Debugging Help needed!

    I've followed the following Excel Tutorial from Youtube: How To Create Word Documents From Excel WITHOUT Mail Merge by Excel for Freelancers. I've attempted to use my own TEST Data (screenshot below): However, when I attempt to Print or Email it doesn't work. I got the below error but...
  2. E

    Debugging or program issue?

    My debugging features don't appear to be working. Wrote some simple code just to work with. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target.Range("A1:A10")) Is Nothing Then MsgBox "Nothing in here" Else MsgBox "something here" End If End Sub Now the code gives...
  3. P

    VBA Hyperlink Debugging

    Hey everyone. I am currently working on Debugging a code that has worked wonders for me for the last 10 years. Here is my code: 1 Worksheets(1).Select 2 R = Range("A65536").End(xlUp).Row 3 For Each Cell In Range("A2:A" & R) 4 Cell.Hyperlinks(1).Follow...
  4. M

    Issue with running several VBA codes (error 13 - debugging)

    Situation: I am building a excel sheet with several automated actions - done with macros. The 1st macro is for creating a new project and it copies the last aktive row with contents and pastes it one row below and clears the cell contents of defined cells in the row. The 2nd macro copies a row...
  5. N

    Excel Code Debug Help Needed

    Hi folks, I hope this is an easy fix because I am going crazy. File 1: https://drive.google.com/open?id=0B1W8cwZVnTmPNjQyX0NhQktURG8 This file is how it is supposed to look. The code for this file was written by another and sent to me. Apparently, the code runs perfectly in Excel 2016 and...
  6. S

    Run-Time Error 5

    I inherited this piece of code for VBA, every time I try to run the program I end up getting a run time error 5. Previously I thought I had it debugged after putting in a pause, but that only worked for so long. I am working in excel 2013. The code is as follows: Sub FAANotice() Dim...
  7. T

    Debugging formulae in Excel

    Is there any facility in Excel (I'm using Excel2010), whereby you can look at part of a complex formula, and immediately see what value that part equates to? Regards, TS
  8. M

    Simple Code Debugging

    Hi MrExcel users, I am new to VBA, and am following along with a youtube channel to learn: (https://www.youtube.com/watch?v=S55cKcgF1jk&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR&index=8#t=0.576114) Although I am following his steps exactly, my VBA sheet needs bugging, and his does not. Is...
  9. D

    Formula Autofill Debugging Help

    Hello, I have a VERY strange error happening in one of my Macros that for the life of me I sure can't figure out. The weird thing is that this was working just fine before and now the error has crept in somehow. Basically I was using a very basic formula in H1 that just calls a value from F1...
  10. W

    VBA Error Handling Tips?

    I am actually fairly new to VBA coding and is at the point where I am trying to learn how to debug a current program given to me by a coworker that I wish to understand and possibly improve to suit my needs. Public Sub Patient_Records() Dim FF As Long, strText As String, strFile As...
  11. A

    UDF Array Formula

    I am writing a UDF that accepts several ranges as parameters. I enter the UDF as an array formula across 14 cells (e.g., C10:P10) and when I first enter it, it seems it gets called 4 times? If I change a cell value that would trigger the UDF to execute, it sometimes gets called once, and...
  12. S

    Wierd Application-defined or object-definer error on running but not when debugging

    I have a very wierd error I cant seem to solve. The error is in the subject and the funny thing is when i debug it and then step through the code (with F8) it works perfectly, with no error, and continues with the expected result. So basicly if I run the code and the error pops up, if I press...
  13. Z

    Sub or function not defined

    The code below automatically calls AddHeaderHours when something is entered into cell G30, this code does work (coded to the worksheet). '--------------------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$G$30"...
  14. Z

    Cannot jump to 'Application' because it is hidden?

    I get this warning when i run my code, and cannot figure out what it means? Would somone be able to tell me? I only have one case within my case statements because i am in the beginning stages. What the program is suppose to do is find the intersection of the two ranges set by the case...
  15. A

    VBA Macro with Pivot Table Question

    Hi guys! So I'm new to creating macros with VBA and am trying to create one (just finished recording and started debugging) that basically encompasses creating a pivot table from a data set, sorting it in the pivot table, running some calculations on the data, and then graphing the results. The...
  16. B

    Debugging my formatting module

    So I don't know what's going wrong with my code, it's just designed to automate a formatting task that I repeat often at work. I've put comments in for all the subroutines to explain them but basically it finds the used range, borders it, formats the headers, uses select case to find specific...
  17. bs0d

    VBA - Accept Column Letters Only as INPUT

    I'm creating a macro that requires user input into pre-defined cell areas. I need only column letters from the user. In the VBA code, I'm screening the input for invalid entries. Rather than write many IF conditions checking for blanks, numeric, length issues, etc. What would be the best...
  18. B

    Insert Macro multiple worksheets

    Hey guy, Below is a macro that I recorded earlier. I know it's poorly written (recorded). This will be used to update several workbooks which are the exact same. I have found a few errors below. I originally copied a formula from another workbook and used that to paste into my new workbook. It...
  19. J

    Excel 2010 debugging problem

    My work was kind enough to give me excel 2010 when my old computer died and it is annoying me as the debugging of VBA is atrocious compared to the 2000 version. It seems that whenever a macro has an error rather than the debugging function popping up excel just decides it needs to close...
  20. C

    Refactoring/Debugging code

    Hi all I have built up a bundle of code which i am trying to refactor and tidy up a bit. In the editor is there a way to see where a procedure is called by looking at the procedure, other than setting breakpoints and running all the main procedures. Any other tips or points to good articals...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top