Loop through each cell in a range of cells when given a Range object

by 
Sub LoopRange()

    Dim rCell As Range
    Dim rRng As Range

    Set rRng = Sheet1.Range("A1:A6")

    For Each rCell In rRng.Cells
        Debug.Print rCell.Address, rCell.Value
    Next rCell

End Sub

More Related Contents:

  1. How can I call a macro which contains a loop but only run one iteration of that loop?
  2. VBA comma separated cells, needt last entry only
  3. How can I find last row that contains data in a specific column?
  4. Open Excel file for reading with VBA without display
  5. Wait for shell command to complete [duplicate]
  6. Are there disadvantages in putting code into Userforms instead of modules?
  7. Difference between ‘on error goto 0’ and ‘on error goto -1’ — VBA
  8. What are .NumberFormat Options In Excel VBA?
  9. Excel: How to check if a cell is empty with VBA? [duplicate]
  10. ShowAllData method of Worksheet class failed
  11. Detect if range is empty
  12. Assign keyboard shortcut to run procedure
  13. Uncheck all checkboxes across entire workbook via CommandButton
  14. return csv file as recordset
  15. VBA workbooks.Close without being prompted to if the user wants to save?
  16. Excel macro -Split comma separated entries to new rows [duplicate]
  17. Get text from clipboard using GetText – avoid error on empty clipboard
  18. Copy a selected range to another worksheet
  19. Benchmarking VBA Code
  20. Excel macro – paste only non empty cells from one sheet to another
  21. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  22. Display milliseconds in Excel
  23. VBA editor auto-deletes spaces at the ends of lines
  24. Application.Quit command not closing the entire Excel Application
  25. Create hyperlink to another sheet
  26. Trying to open the workbook in separate instance
  27. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  28. Create folder path if does not exist (saving from VBA)
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment