Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |