Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Variable equal to........
For i = 3 to 42
For j = 1 To 20 and then refence Cells(j,"B") and Cells(i,"A") -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Aaron" wrote in message ... Great! That makes sense and it works. What about the range of values? Thank you for your help! "Gary''s Student" wrote: Hi Aaron: One step at a time: For i=1 to 10 can be replaced by variables that can be set by cell values istart=Range("A3").Value iend=istart+39 For i=istart to iend So we are using the value in Cell A3 to define the start of the loop -- Gary's Student "Aaron" wrote: I have a macro that is dependent upon a set of variables. Instead of hard coding the possibilities for the variables I want it to use values for the 2 variables from cells in the sheet how would that work? And from a range of values in the spreadsheet? I don't know if this is right or not but something like: For i = "A3" To ("A3" + 39) For j = "B1" To "B20" or "B1:B20" (whatever is correct code) Actually now that I think about it, it would need to be the "B1:B20" version if possible because it is a set of codes not a liniear set of numbers. Instead of: For i = 1 To 10 For j = 1 To 10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA check to see if variable value is odd but not equal to 1 | Excel Discussion (Misc queries) | |||
Setting worksheet name equal to variable value | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming | |||
Set variable equal to a cell value & more | Excel Programming | |||
variable not equal to expression | Excel Programming |