Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable cell index
how can i use variable cell index and "for"loop in Excell.
for example: are E4=E3+1 or A1=Fn;n=1 to 20? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable cell index
as your query i've compiled this one:
Sub Looping() Dim n As Long For n = 1 To 20 Cells(n + 4, "E") = Cells(n + 4, "E").Offset(-1, 0) + 1 Next n End Sub -- Regards, Halim "jila" wrote: how can i use variable cell index and "for"loop in Excell. for example: are E4=E3+1 or A1=Fn;n=1 to 20? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on index addressing using variable sheets & cell references | Excel Worksheet Functions | |||
How to index a variable in VBA | Excel Programming | |||
Can the column index in a cell address be made variable? | Excel Programming | |||
Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
Variable values in Index function | Excel Worksheet Functions |