Adding a "1" to the first cell in a new row

EE Pros,

MartinLiss helped me with a Macro that works great.  However, when I fire off another Macro ("Priortize"), it only works if I have a "1" in the first cell of a newly created row.  All I need is a line that adds a "1" in a new line.  I've attached the workbook for you to take a quick look at.

Thank you in advance,

Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Add this line to the NewestFinCase sub just before the End Sub line

    Range("A" & rngDesired.Row) = 1
Bright01Author Commented:
Quickest right answer I think I ever received!  Thank you ssaqubh.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.