RowCount2 = Worksheets("Permitting and Notification").Cells(.Rows.Count, "A").End(XlUp).Row
If this doesn't work, we'll have to see a sample.