Re: vb code for macro to not execute when blank cell encountered.
the difference is after i modified the code i found that i had to enter a value in all rows in the h column until 200. what i want is in that range H20 to H200 even if i enter one value in either one of the rows then that is acceptable.
have attached a mock file with code for your reference.
thanks again.