Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Ranges
snippet of code below
Ques - when your using the Cells(i) below is it possible to then access a Range by doing something like this?? Range("A"Cells(i) : "E" Cells(i)) In other words once I find what I am looking for I want to do something to the row I am on I usually reference a range like - A3:E3 but since the row is described by Cells(i) how do I use that in a range reference?? For i = 1 To rng.Count If code < rng.Cells(i).Value Then |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable reference ranges | Excel Discussion (Misc queries) | |||
Concatenate a reference to named ranges in other workbook | Excel Worksheet Functions | |||
Named ranges which seem to reference old workbooks/worksheets | Excel Discussion (Misc queries) | |||
How to Variable Reference Row Ranges? | Excel Programming | |||
linest won't accept multiple reference ranges | Excel Worksheet Functions |