VBA Integer Overflow at 70,000

by

The website you are looking at is for Visual Studio (.NET) .

VBA Integer is 32,768. You need to use a long.

A VBA Long variable holds whole numbers from -2,147,483,648 to 2,147,483,647 and uses 4 bytes (32 bits) of memory.

Dim lLastRow as Long

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. VBA Macro for copying and pasting columns on same excel sheet
  4. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  5. Levenshtein Distance in VBA [closed]
  6. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  7. How do I base64 encode a string efficiently using Excel VBA?
  8. Assign event handlers to controls on user form created dynamically in VBA
  9. Programmatic Access To Visual Basic Project Is Not Trusted
  10. Can I make this macro more efficient or faster?
  11. Conditional Formatting using Excel VBA code
  12. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  13. How to get the background color from a Conditional Formatting in Excel using VBA
  14. VBA Excel Populate ListBox with multiple columns
  15. Best workaround for VBA Transpose array length limit?
  16. How to use Events with Option Button Controls on Userform [duplicate]
  17. How do I use variables to set properties in VBA (Excel)
  18. VBA: Else without If Error
  19. Windows().Activate works on every computer except one
  20. How to highlight a cell using the hex color value within the cell?
  21. Convert RTF (Rich Text Format) code into plain text in Excel
  22. lastrow and excel table.
  23. Open a workbook from VBA and disable Workbook_Open() code?
  24. How to filter listbox values based on a Textbox value
  25. Find and FindNext for Excel VBA
  26. Calling regasm without administrative rights for COM interop in Excel VBA
  27. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  28. How do I activate a specific workbook and a specific sheet?
  29. Start VBA macro when editing a cell
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment