Using the target command to start user form macro

The following is code I am using to start a user form macro that will start a dialog box asking the user if they've received approval to exceed a specified threshold:

Please Login or Register  to view this content.

However, I can't get it to work right b/c when I change a cell value in the range I5:U5, the macro does not run (see the bolded portion in the code). I know this code works b/c I submitted a dummy workbook months ago and the code works for the dummy workbook, but when I tried to modify the code to match the actual workbook I am using, I couldn't get it to work right. Furthermore, the range I am working with is not a continous range and I want to make sure I input the right syntax for non-contiguous range as well. Any help would be greatly appreciated

Thanks.

HP RodNuclear

Hello HP RodNuclear,

The Target is a Range object belonging to the Active Sheet. If Sheet8 is not the Active Sheet then the test will fail. The Range objects must be on the same sheet for the Intersect method to return true.

Hello HP,

Got to love those Aha! moments.