Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting a range using row & col numbers?
Is this an efficient way to do this? (Code means nothing except
to illustrate) ' Get a certain range using passed-in row and column values Function getRange(r as integer, c as integer) as Range const maxr = 10 const maxc = 10 dim rng as Range rng = Range(Cells(r, c), Cells(maxr, maxc)) end Function IOW is this a good way to refer to a Range instead of doing Range("A1:J10") syntax. I DO want the function signature to have a row and column parms, unless there's a better generic way. Thsnks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting a range using row & col numbers?
Function getRange(ByRef r As Long, ByRef c As Long) As Excel.Range Set getRange = Range(Range("J10"), Cells(r, c)) End Function Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Net Doe" wrote in message Is this an efficient way to do this? (Code means nothing except to illustrate) ' Get a certain range using passed-in row and column values Function getRange(r as integer, c as integer) as Range const maxr = 10 const maxc = 10 dim rng as Range rng = Range(Cells(r, c), Cells(maxr, maxc)) end Function IOW is this a good way to refer to a Range instead of doing Range("A1:J10") syntax. I DO want the function signature to have a row and column parms, unless there's a better generic way. Thsnks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting a range using row & col numbers?
But this limits it to "J10". I want tp"fully" parameterize
the start/stop rows/cols, so the ByRef r and c are not even necessary. I should have pseudo-coded it this way ' Give me the Range of cells from (r1,c1) to (r2,c2) Function getRange(r1 as integer, c1 as integer _ r2 as integer, c2 as integer) as Range dim rng as Range rng = Range(Cells(r1, c1), Cells(r2, c2)) end Function "Jim Cone" wrote in message ... Function getRange(ByRef r As Long, ByRef c As Long) As Excel.Range Set getRange = Range(Range("J10"), Cells(r, c)) End Function Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Net Doe" wrote in message Is this an efficient way to do this? (Code means nothing except to illustrate) ' Get a certain range using passed-in row and column values Function getRange(r as integer, c as integer) as Range const maxr = 10 const maxc = 10 dim rng as Range rng = Range(Cells(r, c), Cells(maxr, maxc)) end Function IOW is this a good way to refer to a Range instead of doing Range("A1:J10") syntax. I DO want the function signature to have a row and column parms, unless there's a better generic way. Thsnks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select top six numbers from a of range of random numbers | Excel Worksheet Functions | |||
two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
How to add the 10 smallest numbers out of a range of 20 numbers. | Excel Worksheet Functions |