Hello:
I am attempting to select a range of non-adjacent cells for later use in a macro. "i" is set to designate the appropriate row.
Set rng = Sheets("name").Range(Cells(i, 65), Cells(i, 69), Cells(i, 73), _
Cells(i, 77), Cells(i, 81), Cells(i, 85), Cells(i, 89), Cells(i, 94), Cells(i, 99))
Unfortunately, when run I receive the following error:
"Run time error 450: Wrong number of arguments or invalid property assignment"
Is my syntax with .Range(Cells(), Cells(), Cells()) incorrect, or do I have another problem?
Thanks for any help.
I am attempting to select a range of non-adjacent cells for later use in a macro. "i" is set to designate the appropriate row.
Set rng = Sheets("name").Range(Cells(i, 65), Cells(i, 69), Cells(i, 73), _
Cells(i, 77), Cells(i, 81), Cells(i, 85), Cells(i, 89), Cells(i, 94), Cells(i, 99))
Unfortunately, when run I receive the following error:
"Run time error 450: Wrong number of arguments or invalid property assignment"
Is my syntax with .Range(Cells(), Cells(), Cells()) incorrect, or do I have another problem?
Thanks for any help.