Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell References and Looping
I have a Looping question.
I have several rows of data to manipulate.. and want an easy way to increment a cell range. Can I use a variable in the Cell range name itself..? For instance, on each pass I copy the values in A1, B1, C1, etc.. someplace else and do something then increment to A2, B2, C2 etc... Can I replace the (row component of the cell reference) e.g. 1, 2, 3 with an integer variable so that I can write a simple do while or for next loop? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Looping in VB with cell ranges | Excel Worksheet Functions | |||
Faster Way of looping through cell values | Excel Discussion (Misc queries) | |||
syntax for relative cell change and looping | Excel Programming |