On Fri, 16 Nov 2007 20:34:01 -0800, Eric
wrote:

Thank everyone very much for suggestions
I would like refer to specific cells rather than range.
Could anyone tell me how to modify Range("A1:C1") into different cells? such
as A13, A67, A100.
Thank everyone for any suggestions
Eric

Merely change the parameters to the Range Property.

In my contribution, it would be:

Set AOI = Range("A13,A67,A100")
--ron