View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_186_] Leith Ross[_186_] is offline
external usenet poster
 
Posts: 1
Default selection.interior


Hello Eric ,

The problem is with your range assignment...
Range("g12:g61,a12:e61,l8").Select

This type of Range statement can only accept 2 arguments separated by
comma.
Range("G12:G61", "A12:E61").Select

This will select A12 as the Top Left cell in the Range and G61 as th
Lower Right in the Range rectangle .

Before I go on, it would help to know how you want the cells selected
As 3 separate Ranges or what? Let me know.

Thanks,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48092