Re: Creating variables in a loop!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Göran Andersson <guffa@xxxxxxxxx>
Date: Wed, 04 Apr 2007 01:18:55 +0200

Todd Jaspers wrote:

Hey guys,

Is there ANY way to accomplish this: (see below)? Basically, I want to have a loop (a < 3 is just for testing purposes, it will be an underermined amount). In this loop, I want to be able to create a new cell each time. In this cell, I want the variable name to change. Is this at ALL possible? I've never been able to figure this out in some of the other languages.

No, you can't create dynamic variables. Use an array.

--
Göran Andersson
_____
http://www.guffa.com
.

Prev by Date: Re: Under what conditions would Application variables go away?
Next by Date: CASE SOLVED
Previous by thread: Re: Creating variables in a loop!
Next by thread: Change Cursor Style before and after AJAX Request
Index(es):
- Date
- Thread

Relevant Pages

Re: extracting a number
... Maybe this will accomplish your task without using the "LEFT" function ... the cell value without the last digit, then the 1st line in the DO loop ... > remove the last digit of each cell. ...
(microsoft.public.excel.programming)
Re: extracting a number
... Maybe this will accomplish your task without using the "LEFT" function ... the cell value without the last digit, then the 1st line in the DO loop ... > remove the last digit of each cell. ...
(microsoft.public.excel.programming)
Re: extracting a number
... Maybe this will accomplish your task without using the "LEFT" function ... the cell value without the last digit, then the 1st line in the DO loop ... > remove the last digit of each cell. ...
(microsoft.public.excel.programming)
Loop with activecell.offset
... Need to accomplish the following: ... Loop through column B until isEmpty. ... Locate the next cell = "Date" and repeat. ... 'Cell B8 is the first cell found in the loop with the word Date. ...
(microsoft.public.excel.programming)
Re: formula validation
... For Each cell In FormulaRange ... www.cpearson.com "jim" wrote in message ... > The message boxes were just for testing purposes, but the problem is with> the if statement. ... I>> need to do this for a lot of cells, so I am trying to use a loop, but I am>> having no luck. ...
(microsoft.public.excel.programming)