If one cell in line turn empty then entire line turns empty

Hello everyone.

I would like to get some help.

I have a very large worksheet and I would like if, as example, if I delete content of 1 cell in specific line to entire line turn empty together.

How do I do that?

I was thinking in adding a button for "update" the worksheet before closing...

Thanks in advance.

Hello, thank you for your patience and attention, but if possible I would like instead of delete the row, to just clear content on rest of cells of this row...

Would it be possible?

Regards.

Originally Posted by LaffyAffy13

Of course! Check the code, I edited it.

Thank you very much!

But how do I change R1C1 for work only in the range B4:K3000? And if not much work to ignore lines that contain formulas? (is it called formula in english? not sure...)

Originally Posted by LaffyAffy13

Yes, they are called formulas. You want to clear the contents of any row that contains an empty cell, specifically in the range "B4:K3000", but ignore all rows with any cells that contain a formula? Am I understanding that correctly?

No I want macro to ignore specific cells which contain formulas. I have uploaded an sample sheet for better understanding.

Link: http://temp-share.com/show/dPf3UCA5W

In C column if you click from C4 and down you'll see there's a formula for changing suppliers name. I didn't wanted it to be changed...

Thank you again.

Oh my God! You're great!

It seemed so easy to you for making all this long code!

I would like to ask you one more favor if possible. Could you imput after the functions notes like 'here I change the cells colors and so on?

Because I really would like to learn VBA and for that I would like to understand what each thing is doing in the code.

But just if you have time.

Thank you so much!

Originally Posted by LaffyAffy13

Hope that helps!

Thank you!

I know my main question is already solved but I thought in not creating a new thread for one more question about same worksheet.

You see next to columns that should be filled with dates there are a small cell for numbers which goes like this:

If date of billing is like 9/21/13 then it should be filled with number 9 which means month 9 as mentioned on table of caption. At this moment it will be filled manually since I could not make a formula for IF in these cells because of date. Would you know by chance a easy way to automatically fill the number of month right after imputting the date on month cell?

Kind regards!

No problem, you already helped me alot.

Thank you very much!