Macro is skipping rows in a column that need to be filled with a value.

[mDevel]

Hi,

I'm running a macro that filters and enters values of "N" based on the criteria of the filter. The macro is working properly, however upon running it, It's skipping some cells of a column that should have been filled with a value "N".

I attached a copy of a spreadsheet if it helps you guys to help me. Column G "Appraisal" - pass has been unchecked. Column D, "Documentation" has StreamlineWithoutAppraisal unchecked to filter out the two. You'll see that in Column C, the first 2 rows are left blank without an N.

My code is shown below.

Please Login or Register  to view this content.