View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Error when running macro in Excel

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/

.