>Thanks Hilmar
>
>I tried putting the code in the AfterRowColChange and I get an error message:
>
>' No Parameter Statement is Found '
>
>Here is my code:
...
You have overwritten the parameter statement. Put it back. As with any parameter statement, this must be the very first executable statement. It has to be there, whether you use the parameter or not.
The original parameter statement says:
LPARAMETERS nColIndex
Just put this at the beginning of your code.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)