View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Net Doe Net Doe is offline
external usenet poster
 
Posts: 10
Default 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!