Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Last Cell in Range
Hi everybody,
I have a list of 6 numbers in a sheet named "Input" and in Cells "B3:G?". How can I, firstly find the last cell in the Range "B3:G?", and secondly create an array for example for each of the 6 numbers. So "B3:G3" will be one array, "B4:G4" will be another array and so on. I would like to be able to iterate through these then and perform some action. Thanks in Advance. All the Best. Paul |
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) | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
VBA REQUIRED TO TAKE VALUE FROM EACH CELL FROM A RANGE AND FIND THE VALUE FROM A DIFFERENT RANGE | Excel Programming | |||
Find first cell in range and expand range -VBA | Excel Programming | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming |