Worksheet change event code to display message box based on active cell offset content

will this help....it seem to work on the data set I created....ALSO, LAST ROW must be exactly LAST ROW because LAST ROW is not the same as Last Row....you can "wrap" the Rng.Offset(0,-1).value in a UCASE function so no matter how it's in the cell it will convert it to upper case....HTH

Please Login or Register  to view this content.

EDIT: In your next post you might want to explain the problem a little more than "it doesn't work"....because that could mean a lot of things....have a great day