Deleting Rows Inside a macro

[agentred]

Hi Folks,

I have a formula that counts how many rows there are in cell A, then fills the rest of the columns down to match. It works using the "selectionchange" part of the worksheet, and executes perfectly 99% of the time.

Unfortunately, there is a program that fills the data in column A and sometimes the rows in A decrease, but the macro still fills down to the old number of rows, causing excel to divide by zero a few dozen times and crash.

So is there a way that I can have it fill down ONLY if the row is not empty? The code is below

Please Login or Register  to view this content.

I think I need something just before the

Please Login or Register  to view this content.

line but I'm not sure what.

Can I nestle an IF function in there? Or should I end the with... one line early, run the IF, and then finish off the IF function?

Many thanks for your help,

AR

[shg]

Maybe like this, but if can wipe out all the formulas in col F depending on what you do in col A:

Please Login or Register  to view this content.

[agentred]

Maybe like this, but if can wipe out all the formulas in col F depending on what you do in col A:

Hey, thank you, what do you mean it can wipe out all the formulas in col F though? Col A will never be empty, so I think it should be OK... Will try tonight, many thanks,

AR