Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet change macro for paste special | Excel Discussion (Misc queries) | |||
Worksheet change Macro Question | Excel Discussion (Misc queries) | |||
Worksheet change Macro part 2 | Excel Discussion (Misc queries) | |||
Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
Using this Automatic Resizing Macro with Worksheet Change | Excel Discussion (Misc queries) |