Functions to get range properties
That works as a cell formula, but I need it in VBA. So if I do
something like:
Application.WorksheetFunction.Min()
Then the Min() function expects as series of arguments [arg1], [arg2],
[arg3], etc. I don't know how to turn COLUMN(C1:F1) into an array or a
series of arguments without a lot of extra code.
Any tips would be great. I hate writing and using code that re-invents
the wheel, and I have a suspicion that I have.
|