vba error

  1. A

    Evaluate Function isn't Returning Errors

    I'm trying to evaluate the formulas in a table object to check for any errors, and I'm using the Evaluate function to evaluate the formulas and check for any errors. Is there a better or different way of doing this? Thanks! programErrors = Application.Evaluate("COUNTIF(" & progRng.Address &...
  2. L

    All macros have stopped working on all computers, including previous versions that I know worked.

    Hello, I have many macros built into a workbook that I send copies of to my sales team. Over the weekend, everyone's began corrupting unexpectedly. Now, even my old versions of this workbook don't work and we know they did previously. The error when trying to initialize any macro is "Cannot...
  3. emiguy

    VBA to prevent pop up of File XYZ exists

    Hi everyone. I asked part one of this question and it was answered quickly. HOW CAN I FIND THAT THREAD SO I DON'T DUPLICATE IN THE FUTURE?? (uggh....sorry) Goal: I have a 365 macro to save the file as a XLS file, then a PDF. Someone (thank you to that person!!) answered the question, but now...
  4. 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)...
  5. K

    Need to integerate Telegram API with VBA Excel

    I having some issue to integrate my programs to Telegram official API. I'm not a pro guy at it. can anyone help to solve it?
  6. S

    vba Error: Converting Word Doc to PDF

    I generate a Word Document populating the bookmarks within it from excel and then tried exporting to PDF. Constantly getting error even after adding Microsoft Word Library 16.0. What am I doing wrong here? The code points to wdExportFormatPDF as Variable not Defined. <code style="margin: 0px...
  7. Small Paul

    VBA Fails When Only 1 Line of Data

    Hi I have a vba which starts with the following: ActiveSheet.Name = "Salesforce Download" Dim lastrow As Long Application.ScreenUpdating = False Application.DisplayAlerts = False Setmyrange = range("A2", "A" & Cells(Rows.Count, 1).End(xlUp).row) Application.ScreenUpdating = False...
  8. S

    Run-time error 3343 - Is there a solution

    I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...
  9. J

    Change the values of a sheet based on negative and positive calculation of another sheet

    I have 4 sheets, Sheet1, Sheet2, Temp, Base Price in sheet1 I have 2 columns Product code and Values, In sheet2 also I have 2 columns Product code and Values, In sheet1 A column a same product may be there for more than one time with different values but in sheet2 the product code is there only...
  10. S

    VBA Loop

    Hi All, I am having issues with loops in VBA, I am convinced it should work but doesn't & I have no clue why! Sub SiteReports() Dim T As Integer Dim fldr As FileDialog Dim sItem As String Application.ScreenUpdating = False Set fldr = Application.FileDialog(msoFileDialogFolderPicker)...
  11. tlc53

    VBA Code Error - Reveal next line in multiple areas

    Hi there, I use the below code to automatically reveal a row as the user enters details. It's been working fine but in this case, there are many ranges to take into account and when I tried to put it all under one, it came back with a syntax error (it's too long). Therefore, I am trying to...
  12. S

    VBAProject properties prompting for password when protection is not enabled

    Recently, I had a project password go corrupt (still not sure how, literally a case of one day the password worked, the next day it didn't) and I had to use a macro-based workaround to re-establish access in VBA. During this process, I disabled the protection as the excel tool I created wasn't...
  13. D

    Error while running VBA

    Hi all, while running the below VB i am facing with the Error " Compile error: Sub or Function not defined" and when i click on okay it highlights the line marked in yellow below. Please assist, thanks in advance. Regards Debraj Patra Sub MergeAllWorkbooks() Dim MyPath As String...
  14. B

    Intermittent 400 and 1004 VBA errors with a macro to save the active worksheet as a PDF file

    Earlier this month I was trying to figure out how to add a print button to a worksheet to print selected cells as a PDF document - https://www.mrexcel.com/forum/excel-questions/1037201-add-print-button-worksheet-print-selected-cells-pdf-document.html - which as you can see from that thread, I...
  15. A

    Run Time Error 53 Code

    Can someone please help with this code. I have a file "AA" that I am looking to take data from my larger file, have it pasted into this file in a certain format and save the data in a certain naming convention as an XLSX and a PDF. However, I am having lots of trouble with this. I have the code...
  16. S

    Copy Columns from one Workbook into another

    Copy Columns from one Workbook into another, looping through sheets 6 to the last in the worksheet. Error message Compile Error: Duplicate declaration in current scope Sub CopyaColumnToWorkbook() Dim SourceWkb As Excel.Workbook Dim TargetWkb As Excel.Workbook Set SourceWkb =...
  17. A

    Why will my loop not move through different worksheets (tabs)

    I have two different workbooks that I am utilizing for this macro. 1.) "zAward Template - Test - Copy" 2.) Appendix A I have written a macro that essentially takes the data I need in the template file from a tab and paste what is necessary to populate the appendix, does lookups to data, saves...
  18. C

    Nested macros not looping correctly.

    Hi, I have a super macro that is giving fits and I'm not seeing why. It is made of macros that call other macros (all of which work correctly on their own). The SuperMacro needs to run from one workbook that opens other workbooks and activate their macros. SuperMacro and one of its nested...
  19. M

    VBA Macro issue-excel spreadsheet to PDF with password encoding

    Good afternoon. I am hoping someone can help me out. I have a new job that requires me to run a VBA Macro. The macro is supposed to create a PDF document from an Excel Spreadsheet and encode it with a password. When I run the macro I get an "Run time error "429": ActiveX component can't create...
  20. S

    VBA run-time error '438':

    Limited VBA conceptual understanding. Using Excel 2010 Binary file type. Attempting to modify three simple graphs (on same worksheet) by overriding scale minimums and maximums with cell references in same worksheet. Unfortunately, I am getting a VBA error that I have done some limited...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back