I think the problem is that the range's definition exceeds 255 characters.
How about breaking this up into sub areas and testing each one until the
intersect is not nothing?

--
Jim Rech
Excel MVP
"neowok " wrote in message
...
| basically i have this code
|
| With Target
| If Not Intersect(.Cells,
| Range("$C$7:$E$7,$G$7:$I$7,$K$7:$M$7,$O$7:$Q$7,$S$ 7:$AC$7," & _
| "$AE$7:$AG$7,$AI$7:$AK$7,$AM$7:$AO$7,$AQ$7:$AS$7,$ AU$6:$AW$7,
| $AY$7:$BA$7, $BC$7:$BE$7," & _
| "$BG$6:$BI$7, $BK$6:$BM$7, $BO$6:$BQ$7, $BS$6:$BU$7, $BW$7:$BY$7,
| $CA$7:$CC$7," & _
| "$CE$7:$CG$7, $CI$7:$CK$7, $CM$7:$CO$7, $CQ$7:$CS$7, $CU$6:$CW$7,
| $CV$7:$DA$7," & _
| "$DC$6:$DE$7, $DG$7:$DI$7, $DK$7:$DM$7, $DO$7:$DQ$7, $DS$3:$DU$5")) _
| Is Nothing Then
|
| theres 30 items in that range, and excel is refusing to allow it, it
| just says "method 'range' of object '_worksheet' failed". I tried to
| define a named range but excel only seems to allow 9 items in that,
| clicking a 10th unselects the whole lot.
|
| must be a way i can have this list and be able to use it in the above
| code?
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|