• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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,

B.
Risk-Graphic-v7.xlsm
0
Bright01
Asked:
Bright01
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Add this line to the NewestFinCase sub just before the End Sub line

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

B.
0
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now