How do I declare a global variable in VBA?

by

You need to declare the variables outside the function:

Public iRaw As Integer
Public iColumn As Integer

Function find_results_idle()
    iRaw = 1
    iColumn = 1

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Sequence of numbers based on start and end value of 2 cells [closed]
  3. Function to convert column number to letter?
  4. How to use the Implements in Excel VBA
  5. How to pause for specific amount of time? (Excel/VBA)
  6. VBA code doesn’t run when cell is changed by a formula
  7. Easiest way to loop through a filtered list with VBA?
  8. What is the difference between dim and set in vba
  9. Change date format using substitute or replace
  10. Parsing an ISO8601 date/time (including TimeZone) in Excel
  11. Getting the actual usedrange
  12. Delete a row in Excel VBA
  13. VBA: Convert Text to Number
  14. Iterating through populated rows
  15. How can I run VBA code each time a cell gets its value changed by a formula?
  16. How to convert 32 bit VBA code into 64 bit VBA code
  17. Using VBA to detect which decimal sign the computer is using
  18. Referencing Excel Userform Control Name Value From String (VBA)
  19. Fill formula down till last row in column
  20. If string contains word from list, return value adjacent to list value
  21. Refreshing all the pivot tables in my excel workbook with a macro
  22. Countif With Multiple OR Criteria
  23. Vlookup to copy color of a cell
  24. every possible combination of the contents of 2 columns in excel
  25. excel vba freeze pane without select
  26. How to delete rows in Excel based on criteria using VBA?
  27. Converting a string representation of a constant into a constant?
  28. Macro to export MS Word tables to Excel sheets
  29. VBA WinHTTP to download file from password proteced https website
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment