VBA does not accept my method calling and gives Compile error: Syntax error [duplicate]

by

Remove the parentheses.

SavePendleValues sheetrow, sheetrow

Otherwise you are trying to pass as a first argument something in parentheses that has two variables in it, which doesn’t make sense for VBA parser.

More Related Contents:

  1. Windows().Activate works on every computer except one
  2. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  3. What does status=canceled for a resource mean in Chrome Developer Tools?
  4. How to copy Outlook mail message into excel using VBA or Macros
  5. VBA macro that search for file in multiple subfolders
  6. Visual Studio debugger – Displaying integer values in Hex
  7. Getting ScriptControl to work with Excel 2010 x64
  8. For Loop not fully cycling in excel VBA [duplicate]
  9. Get list of Excel files in a folder using VBA [duplicate]
  10. Stop and continue execution from debugger possible?
  11. Accessing SQL Database in Excel-VBA
  12. Save each sheet in a workbook to separate CSV files
  13. Chrome: Uncaught SyntaxError: Unexpected end of input
  14. Export each sheet to a separate csv file
  15. Wait until Application.Calculate has finished
  16. Detect if range is empty
  17. Checking if a worksheet-based checkbox is checked
  18. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  19. excel vba- extract text between 2 characters
  20. Count the number of rows in another sheet [duplicate]
  21. VBA equivalent to Excel’s mod function
  22. VBA Password Input with Cancel Function
  23. Pointers needed for speeding up nested loop macro in VBA
  24. ‘1004’: “The sort reference is not valid.”
  25. Create hyperlink to another sheet
  26. Functions debugging in VS Code
  27. Simple VBA array join not working
  28. How do I activate a specific workbook and a specific sheet?
  29. ReDim Preserve “Subscript Out of Range”
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment