debug

Hi all I am writing a VBA code to copy charts from Excel to Powerpoint. The code is running fine in debug mode, however, gives an error in compile mode. Can anyone please help? Thanks in advance. MBSheet.Activate MBSheet.ChartObjects("Chart 1").Chart.ChartArea.Copy mySlide.Select With...

Hello, I want to delete all rows if column N reads "NULL". I was given the last two lines of this macro a while back from someone (I believe from this forum) and it has worked in the past. I applied this to my current macro but I am getting a debug error when I get to the last 2 lines. Can...

I have copied VBA code from the internet and edited myself to create some invoices, Every time I run the code I get the above error and ask me to debug. Can someone please help me??

I have the following code working as part of a macro without any issue... of course, when I get to my client, I get a debug error... The topRow and botRow variables are storing numbers and in debug mode, when I hover over them, the correct numbers are showing. Any thoughts on a better way to...

I am using the below code. However, when I delete any contents from any cell I am getting a debug error. Can't figure out why. Private Sub Worksheet_Change(ByVal Target As Range) 'search If Target = Range("Q11") Then If InStr(1, Range("Q11"), "Search") > 0 Then Search End If End...

Ok so I am trying to automatically have my form in excel change things to proper case when entered. I found a code that works but then seems to crash excel or kick me to debug here is what I have please help in fixing it so it works. Private Sub Worksheet_Change(ByVal Target As Range) 'Update...

Hi all, Hoping someone can help! When running the macro below, I am getting a run-time error 1004 - No cells were found error. I have tried diagnosing this issue myself, but am at a loss. This macro worked perfectly on the worksheet it was originally created on. So I used that worksheet as a...

Hi everyone, When running a macro, I am getting the following runtime error: Run-time error '1004': Method 'Range' of object '_Worksheet' failed When I click 'Debug', it takes me to the line of code that isn't working, which is highlighted in blue below: Dim ary As Variant Dim i As Long...

My spreadsheet takes totals and subtracts totals. I have about 6 columns and rows that are filled with data. If I try to insert a new row I get a debug error. The debug highlights "Application.Undo" Not sure why any suggestions? Private Sub Worksheet_Change(ByVal Target As Range) 'copies the...

I created the following code below and attached it to a button allowing me to enter a number into Cell A3, click my button and it displays the needed information from another worksheet. Overall it works, but I continue to get a "Run-Time error'424'" msg. What am I missing? Sub ShowDispo()...

I've some strings called "MyEncode1", "MyEncode2", "MyEncode3" etc and passing 1 2 or 3 to a function (as n), wanting to see the one corresponding to n. It won't work! I can go to the immediate window and debug print e.g. MyEncode2 fine but debug print MyEncode & n fails. There's probably a...

Greetings All, I am unfamiliar with VBA so reaching out to anyone who can help me debug why the macro named "Sheet2.ShowMembership" runs into "Object required" error message when fired? The macro in question basically turns column A & B (last name & first name) into bolded text with yellow...

If month <= 9 Then source_dizin = "G:\HOME\MALIKONT\_Hazine_Kontrol\TCU_" & year & "\Bilanço_Kontrolleri\Core_Pozisyon\(0" & month & ")_" & mmonth source_file = source_dizin & "\CORE-MİZAN Pozisyon Kontrolü_" & year & "-0" & month & "-" & first_day & ".xlsx" Else source_dizin =...

Hey all, Getting a runtime error when trying to save worksheet an send as email. This is the highlighted line I'm seeing when hitting debug. excel- 2010 strFileName = ws.Cells("1", "Q") & ".xlsm"

Hello, I am using error handling in my macro using On Error GoTo and part of that is Debug.Print Err.Description which gives me the error in the Immediate Window but does not tell me which line the error is on as it would in Debug mode. How can I make it do this? Thanks

Hi everyone, new member here. I've never had any formal training on VBA, I've always just read a little here and there, and then gone the trial and error route. I was working on adding some new procedures to a coworkers code and thought I'd try to modify his code a bit in an attempt to make it...

I sent a Spreadsheet to a co-worker of mine. We have enabled macros and all that kinda stuff. When he saves it to his work space and opens it and then runs the macro it immediately goes to debug. We both have 2016 version. I sent him several worksheets an they all do the same thing. Any ideas?

Is there anyone who can debug the macros in the attached .xlsm file. The professional can easily correct the mistake. I'm not able to do that. The process: It is a simple VIN Decoder. I load the list of VIN numbers of cars, and it shows me information about the cars. The Problem: Validate VIN...

Hi guys, I've created a sheet for clients to fill in, some cells are mandatory and require filling in. I have no problem with the blank cells, however some contain drop down boxes with the title "click here to select" or "click here for more options" Obviously if the cell remains as "click...

Hi can anyone help me check what's wrong with this code? Sub copyTodifferentsheet() Dim i As Integer Dim Priority As String Dim Task As Range i = Sheets(1).Range("A4").Value Do While i <= Sheets(1).Range("A4").End(xlDown).Value Set Task =...