View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
leonidas[_16_] leonidas[_16_] is offline
external usenet poster
 
Posts: 1
Default Can you shorten these macros?


Hi Bob,

Thanks! Both macros work fine now!
The problem with the run-time error was mine. I have a non-continuou
range of comboboxes, so if the number goes from 15 to 17 an erro
occurs. By adding "On Error Resume Next" this problem is solved.
Thanks again for your help

--
leonida
-----------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=55394