View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ste mac ste mac is offline
external usenet poster
 
Posts: 117
Default overflow error 6.. the macro just stops any idea why?

Integers are signed numeric variables that can store numbers
between +/-32K. Use a Long instead of an Integer.


Many thanks to Julie and Chip, back up and running again

cheers to both

ste