ExcelBanter - Defining Loop Ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Defining Loop Ranges (https://www.excelbanter.com/excel-programming/375833-defining-loop-ranges.html)

Defining Loop Ranges

I want to set the loop range to be equal to the value of two cells.

Example:
For i = "Value of Cell A1" to "Value of Cell B1"

Next i

Thanks for your help,
Scott

PCLIVE

Defining Loop Ranges

For i = range("A1").value to Range("B1").value

wrote in message
oups.com...
I want to set the loop range to be equal to the value of two cells.

Example:
For i = "Value of Cell A1" to "Value of Cell B1"

Next i

Thanks for your help,
Scott

[email protected][_2_]

Defining Loop Ranges

Thanks.

PCLIVE (RemoveThis) wrote:
For i = range("A1").value to Range("B1").value

wrote in message
oups.com...
I want to set the loop range to be equal to the value of two cells.

Example:
For i = "Value of Cell A1" to "Value of Cell B1"

Next i

Thanks for your help,
Scott

All times are GMT +1. The time now is 01:35 AM.