Hi NewGuy

What's your function doing? You can pass an array of arguments eg
ranges to a function by using the ParamArray keyword eg:

Function myFunction(ParamArray xArg() As Variant)

But without knowing more of what you are trying to achieve, it's
difficult to know if this or something else will be suitable.

Best regards

Richard


NewGuy wrote:
I'm trying to omit cells in a given range without using mulitple ranges. I
have a large range of cells with a large number of cells I don't want to
include in my function. However, due to the layout of my worksheet (and I
can't change it), I can't arrange the cells so that all needed cells are in
one block. Any suggestions?