Modify Auto Clear - VB Code

Hello,

I have the following code which I am attempting to recycle into another workbook

Please Login or Register  to view this content.

I need to modify this a bit and I am coming up short ...

First .. when a number is entered into D3:D350 the current date will prefill on H3:H350
And as per above if the number in D3:D350 is deleted it then auto clears H & G ... However I would like to clear the entire row.

So if I Delete the number in D3:D350 I would like all data in A, C, E, F, G & H to autoclear.

Hi,

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Slight modification needed in this autoclear code ...

I have a vlookup in column B ...

Can we tweak the following code to exclude clearing Column B ?

Because B will clear once there is no data in C

I don't want the below to earse by vlook up formula in Column B

Originally Posted by abousetta

Hi,

Please Login or Register  to view this content.

Maybe try:

Please Login or Register  to view this content.

Originally Posted by abousetta

Maybe try:

Please Login or Register  to view this content.

The above did something funky ... so I just did this messy but it works:

Please Login or Register  to view this content.

*** Part of the code above clears the data in cells when the data is deleted from D
*** Can a pop up be added to asK

"Are you sure you want to clear the data in this row"
With an option:
Yes - exceute code above
No - Does not exectute code to clear

Another way:

Please Login or Register  to view this content.