Code rewriting over the same row.

  • Hello,


    For all intense and purposes this should be going down 40,000 rows and coming back up to the row below the last one entered. At least that's what I want it to do.

    The information is coming from combo boxes in a userform, and I have all the columns lined up.


  • All those Selecting of sheets and cells will slow the code and is unnecessary.


    You don't even use the variable ws correctly.


    I think this is what you are trying for


  • The sheet has headers and some options above where the data goes. I found the current code will work if I enter data on the first line. Becaue it then comes up to the line below... I would rather have it more precise because I may expand on my header/dashboard in the future. Thanks for your help!


    Adam