Hi,
Thank you for the quick answer! The code works nice when
it is a permanent table (always the same number of columns
and lines). The problem is when there are zero values in
the labels column. For instance: airport A has a volume of
123, airport B 145, etc... and at the last lines of the
list, airport 0 (zero) has a volume of 0(zero). The macro
is unable to find the names.
I would like just not this message to show.
I´ve tried to insert before the macro the
Application.DisableWarning = True line but it did not work.
Thanks!
Raphael
-----Original Message-----
It sounds to me like the code is doing what you want it
to do even
though you are getting an error. I would suggest hitting
Debug (rather
than end) and finding which line is giving the error.
Then comment it
and everything below it out (since it is not running).
K
---
Message posted from http://www.ExcelForum.com/
.