Using a variable for row in (row,column) for a range in VBA

by

You would do it this way:

Range("C" & processRowBegin & ":C" & processRowEnd).Select

Range takes either two cells or a string to denote the extents.

To do it by the two cells:

Range(Cells(processRowBegin,3),Cells(processRowEnd,3)).Select

A couple notes:

  1. One should avoid using select and simply do what is desired with the cells. For more information on how to avoid it see this POST

  2. One should always qualify all all range objects to their parent sheets. If using the Cells() they too need to be qualified

Example

With WorkSheets("Sheet1")
    .Range(.Cells(processRowBegin,3),.Cells(processRowEnd,3)).Value = .Range(.Cells(processRowBegin,5),.Cells(processRowEnd,5)).Value
End With

More Related Contents:

  1. Format Cell Contents
  2. Excel formula checklist in employees
  3. How do I put double quotes in a string in vba?
  4. Excel VBA – How to add dynamic array formula
  5. How can I URL encode a string in Excel VBA?
  6. Compare double in VBA precision problem
  7. Row count on the Filtered data
  8. Excel VBA Macro: User Defined Type Not Defined
  9. Automate IE via Excel to fill in a dropdown and continue
  10. VBA – Write all possible combinations of 4 columns of data [duplicate]
  11. Remove duplicates from array using VBA
  12. How to automatically insert a blank row after a group of data
  13. Get File Path (ends with folder)
  14. Get length of array?
  15. Email a single attachment from folder of files each to a different person
  16. Export chart as image – with click of a button
  17. Unicode string literals in VBA
  18. Error13 in Excel VBA in data file
  19. How to get the path of current worksheet in VBA?
  20. Excel VBA to match and line up rows
  21. Change font color for a part of text in cell
  22. Create a new object using the text name of the class
  23. Excel cell from which a Function is called [duplicate]
  24. How to extract text within a string of text
  25. How to open a workbook specifying its path
  26. GET pictures from a url and then rename the picture
  27. Create folder path if does not exist (saving from VBA)
  28. Access files with long paths (over 260)
  29. Concatenate multiple ranges using vba
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment