Hi there,
I'd like to seperate a range to n different ranges then
pass these ranges as parameters to a function in Visual
Basic separately.
I use:
Set myRange = Excel.Range(OldRange(1, 1), OldRange(99, 1))
to make a new range "myRange", which has the first 100
value in old range "OldRange"

It works fine in VBA, but in VB it is failed.

Any suggestions? Thanks,

Lee