here it is clearer..
If Sheet(LNEM) IsThisDataOnThisSheet = True then
Sheet(ExtraLNEM) IsThisDataOnThisSheet = true
msgbox "The data to be removed can't be found."
I hope this appears clearer!