View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vick Vick is offline
external usenet poster
 
Posts: 63
Default Worksheet Change Macro Help

I need a worksheet change macro that can do the following. For cells B16,17,
18, 19, 20, 24 - 28, and 31 -34, i would like to have those cells checked for
cell lengths greater than 1024 characters. If they are over 1024 characters
display a msg box stating that. I would also like it to automatically resize
the row on which the cell is changed. I can do this outside of a worksheet
change, but I would really like this to be automatically done for the user
when they change one of the cells listed above. Any help is greatly
appreciated.

Thanks