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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Ranges
Something like:
Range("A" & Cells(i) & ":E" & Cells(i)). cells(1)=3 ?Range("A" & Cells(1) & ":E" & Cells(1)).Address $A$3:$E$3 Regards Trevor "Chris" wrote in message ... 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 |
Reply |
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 |