Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VB to find next cell in range
You can treat the range as a vertical array of Cells and access them by
index:. With Range("A3:A350") Debug.Print .Cells(1).Value 'cell A3 Debug.Print .Cells(2).Value 'cell A4 Debug.Print .Cells(3).Value 'cell A5 ... Debug.Print .Cells(.Cells.Count).Value 'cellA350 End With Range("A3:A350").Cells.Count gives the total number of cells in the range. You could access the entire series in a counter controlled loop. Bob Kilmer "Tim" wrote in message ... Can someone help me find the code that will allow me to find the next cell in a range. I have a range set up, i.e. Range("A3:A350"), and a range variable set to the first cell A3. As my code executes I need the range variable originally set to A3 to move down the larger range of ("A3:A350"), say to A4. I thought the Next property might work but I am having trouble with it. Any help would be appreciated!! Tim McPhillips |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
Find a Cell Value In a Range | Excel Worksheet Functions | |||
Find Cell in Named Range | Excel Worksheet Functions | |||
Find if any cell in range is above Zero | Excel Discussion (Misc queries) |