Thread: How do I have VBA return the trendline types possible for given d.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default How do I have VBA return the trendline types possible for given d.
Trap the error - provide an error handler?

--
Regards,
Tom Ogilvy

"KTimblin" wrote in message
...
I have an Excel VBA program which applies each trendline type to data then
chooses the option with the best R^2 value. How can I have the program
skip
unavailable options? For instance when I make the data very strange Power
and
Exponential regressions are not available. This causes my macro to crash.


Reply With QuoteReply With Quote