//prepare Range operator token
operand.setType(TokenType.OP_IN);
operand.setValue(":"); //as a Range operator
if (var1) {
//lookup NameRange
final Range rng = book.lookupNameRange(cell1);
if (rng != null) {
ranges.add(rng);
operand.addOperand(new Token(rng, TokenType.OPERAND, TokenSubtype.RANGE));
} else {
operand.addOperand(new Token(cell1, TokenType.OPERAND, TokenSubtype.VAR));