HI ,
Thanks for the help.
I am able to generate a warning message with the below code.But when I entered space and executed it is not generating any warning messages, it is directly calling my sub program. I tried with the trim of the cell.value but still the macro is not generating any warning.Is it possible to generate warning for spaces, or to keep some additional check like, if the first character in the D1 should be always a alphabet B.. some thing from preventing the subprogram to fire if D1 is null or if it contains spaces.
Thanks,
Nithya
Bookmarks