Running a macro without affecting formulas.

[Teblol]

I am looking to use my formula that cleans up my "Raw" sheet, but every time I run it the formulas on my "sample data" sheets get messed up. Anyone know a way around this? Please reference the form I included.

Sample Workbook1.xlsm

*Wasn't sure if this was a macro or formula question. If it should be moved to macros can a mod please do so?*

[6StringJazzer]

When you delete rows, formulas that refer to those rows will give #REF! errors because they don't exist anymore. That's the way Excel cell referenced are designed. I am assuming that's what's happening. To fix this, fix your formulas (not your code). See attached. The formulas will always refer to the desired row, regardless of deletions and insertions.

By the way, when you describe a problem please be more specific than "messed up". Always give error codes, error messages, etc.

BTW it was a macro question but a formula solution so I left in this subforum.

[Teblol]

Very cool trick! I will make sure to note that one down. Thanks for your help. I will also make sure to make my post more detailed next time regarding the error codes. Thanks for the info.