Disabling cells in xls

Hi all,

I need a help to slove a problem in my xls code. Below is the code which I used for disbaling a cell with a particular cell. For eaxampl in column D if D2 is marked as "Terminated" then it will disable I2 and J2 which will display the word NA. I want this to from D3 to D50 and if the value of any cells from 2 to 50 is terminated then it should disbale its corresponding I and J cell and display NA. below is the code for it.

Please Login or Register  to view this content.

Thanks
Rishi

Hello Blue07,

The macro now responds only to cells D2:D50 and changes the cell in the same row for columns I and J.

Please Login or Register  to view this content.