':' is not an operator, simply a delimiter - read up on
range opbjects

Set myRange = mySheet.Range("I11:K13")
myRange.Value = 1

I you turned on the macro recorder, selected a range then
examone the code, you will see this. Rememberthat the
recorder is a fairly easy way to review code methods.

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
Hi
I can not find anything about the range operator ':',
union operator ' ' or the intersection operator ','
anywhere in MSDN. I want to know how to use them?

Set myRange = mySheet.Range("I:I,J:J,K:K
11:11,12:12,13:13")
myRange.Value = 1

For example I thought that the above code would put 1
into
the range I11:K13

Best regards
/Niklas
.