tammyl
11-27-2008, 11:50 PM
Hi,
I wish to refer to a large number of individual cells in a range.
So far i have
CalRng = Range("A4", "C4", "E4", "G4", "K4", "M4", "O4", _
"A10", "C10", "E10", "G10", "K10", "M10", "O10", _
"A16", "C16", "E16", "G16", "K16", "M16", "O16", _
"A22", "C22", "E22", "G22", "K22", "M22", "O22", _
"A28", "C28", "E28", "G28", "K28", "M28", "O28", _
"A34", "C34", "E34", "G34", "K34", "M34", "O34")
vba calling code is
For each c in CalRng.....
But I get a Compile error that states:
Wrong number of arguments or invalid property assignment.
I do not wish to check every cell in the full range("A4:O34")
Hope someone can assist.
Much appreciated.
Cheers tammyl
I wish to refer to a large number of individual cells in a range.
So far i have
CalRng = Range("A4", "C4", "E4", "G4", "K4", "M4", "O4", _
"A10", "C10", "E10", "G10", "K10", "M10", "O10", _
"A16", "C16", "E16", "G16", "K16", "M16", "O16", _
"A22", "C22", "E22", "G22", "K22", "M22", "O22", _
"A28", "C28", "E28", "G28", "K28", "M28", "O28", _
"A34", "C34", "E34", "G34", "K34", "M34", "O34")
vba calling code is
For each c in CalRng.....
But I get a Compile error that states:
Wrong number of arguments or invalid property assignment.
I do not wish to check every cell in the full range("A4:O34")
Hope someone can assist.
Much appreciated.
Cheers tammyl