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!