Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Non-contiguous Range limit?
Hi all
I have a grid of non-contiguous cells that I wish to give a name from within a Subroutine either by using Name.Add "MyName", Selection or by using rngTemp.Name="MyName". The problem is that once I get over about 220 distinct cells in the non-contigous range an error message is thrown up each time I try to give it a name. Any fewer cells and it works fine. Is this an Excel 2000 limit? Thanks Mark --------------- www.mfdabbs.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
Non-Contiguous Named Range? | Excel Discussion (Misc queries) | |||
Non-contiguous named range | Excel Discussion (Misc queries) | |||
SUMIF non-contiguous range | Excel Worksheet Functions | |||
Non Contiguous range and loops | Excel Programming |