Defining Loop Ranges

's Computer Specifications

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

's Computer Specifications

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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

's Computer Specifications

Thanks.

PCLIVE (RemoveThis) wrote:
> For i = range("A1").value to Range("B1").value
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Defining Ranges	=?Utf-8?B?U3RldmU=?=	Microsoft Excel Worksheet Functions	5	28th May 2005 07:41 AM
Re-defining Ranges in VBA	=?Utf-8?B?YWVoYW4=?=	Microsoft Excel Programming	3	24th Mar 2005 05:15 PM
Defining ranges	Sivodsi	Microsoft Excel Misc	2	29th Sep 2004 11:43 PM
Defining ranges	Sivodsi	Microsoft Excel Misc	1	29th Sep 2004 01:00 PM
Defining Ranges	Greg Ghavalas	Microsoft Excel Programming	2	9th Jul 2003 10:10 PM