View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
OrientalPearl OrientalPearl is offline
external usenet poster
 
Posts: 39
Default Error capture mechanism, then 'End' or 'Exit Sub'?

Thanks Dave for your prompt help! The two solutions both work well. Re
iserror, I looked up ISNA() and it seems more specialised on working
with '#N/A'. But why doesn't it in this case? Also, '.Text' and
'.Value' do things diffferently? (apparently they make the difference
here)

Ok. I will stick to 'Exit Sub' then. Save a bit of effort in choosing
from the two ;-)

You help is highly appreciated!! Thanks!