Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Too Many Nesting Cells

3 views
Skip to first unread message

craig

unread,
Feb 27, 2007, 3:54:45 PM2/27/07
to
I am using a macro to sort data. I have 6 columns and 20 rows of
data, therefore 6 individual macros which can sort the data to the 6
different parameters. These individual macros work fine. Then, I
have a Master macro which I set up to run the first of the 6 macros,
copy the top 10 and paste on another worksheet, and so forth for the
rest of the 5 indivual sort marcos. Ideally, this will result in data
of 6 columns and 10 rows of the top 10 results from the individual
macros. I have set aside on this worksheet an area that counts and
gives the total number of like items in this data of Top 10. Part of
the Master macro then sorts these numbers in descending order.

The macro finally erros out with Too many nesting cells.

craig

unread,
Mar 1, 2007, 3:34:38 PM3/1/07
to
My problem was that the named cells for one of the macros had
changed. Not sure how this happened but once I got the correct cells
associated with the macro, it all worked.

0 new messages