| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Parameters
XL2002
In a For ...If loop I want the range to change according to the value of the loop, but how? For example For cy = 1 to 70 Range("E cy") = 'something' Next cy In other words :- put 'something' in E1 and then E2 etc. up to E70 How do I get the "text" in the Range instruction to change with each variation of *cy*? [hope I've explained this OK] Many Thanks Bertrand |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum without Range Parameters | Excel Worksheet Functions | |||
| How can I sum a range using two parameters (eg location & date) | Excel Discussion (Misc queries) | |||
| change parameters of a range to be summed | Excel Worksheet Functions | |||
| Range Parameters in Function | Excel Programming | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Threaded Mode
