Fellas,
I am having a trouble with a macro and would very much appreciate your help.
my structre is:
Column 1 31 columns in the middle Column 33, aka cols4 PH some data Y some data
The code is in worksheert_change sub.
What I want the code to do is upon a change of sheet (i have set it to 'upon change in a specific range'), for each row, if column 33 is Y and column one (33 - 32) is either "PH" or "", undo the action an sho msgbox.Please Login or Register to view this content.
Not sure why I am getting overflow error.
Any help is much appreciated!
Cheers!
Bookmarks