Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving an entire range and a for loop question
If I have a range of cells that is a row (eg. A1:E1), how do I increment it
by one row (eg. to make it A2:E2)? Furthermore, since VBA seems to lack the matrix access style of Java or C (ie. matrix[i][j] access), I think I need to use a for loop to access all of the cells in my range by using 'For Each cell In MyRange'. However, I have a static set of fields I want to fill the cells with (ie. A# needs to be from O2 on sheet4, B# needs to be from K5 on sheet4, etc), and I will be repeating this operation for several rows. How do I specifically select this? I was considering use a for loop with an integer parameter and then using a Select Case statement, but that seems rather inelegant. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Moving An Entire Row From One Sheet To Another | Excel Discussion (Misc queries) | |||
Moving entire rows | Excel Programming |