Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determing a range from numerical data
I am trying to code the corresponding range of cells as the result of
numerical data without success. What would be the code of the following example : Range A12 to C22 A12 is known and C22 is the result of a counter that gives the number 22 Range("A22: ????? ).Select Thanks for your help. Moises |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determing a range from numerical data
Can't really tell where you want the range to go.
But for starters (using R1C1 notation), adjust as needed. Dim rng As Range On Error Resume Next Set rng = Range(Cells(Range("C22").Value, 1), Cells(Range("C35").Value, 3)) If Not rng Is Nothing Then rng.Select End If -- steveB Remove "AYN" from email to respond "Moises" wrote in message ... I am trying to code the corresponding range of cells as the result of numerical data without success. What would be the code of the following example : Range A12 to C22 A12 is known and C22 is the result of a counter that gives the number 22 Range("A22: ????? ).Select Thanks for your help. Moises |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determing a range from numerical data
"Moises" wrote in message ... I am trying to code the corresponding range of cells as the result of numerical data without success. What would be the code of the following example : Range A12 to C22 A12 is known and C22 is the result of a counter that gives the number 22 Range("A22: ????? ).Select Thanks for your help. Moises Range("A22:C"&counter).select should do it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determing n=? using COUNT | Excel Discussion (Misc queries) | |||
Determing Range Criteria | Excel Worksheet Functions | |||
Entering numerical range | Excel Discussion (Misc queries) | |||
Determing Value From Date | Excel Discussion (Misc queries) | |||
Determing first row in VBA when subtotaling | Excel Programming |