VBA to Automatically Increase the Last Used Value in a Column

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    Hello again,


    Thanks for the sample worksheet ...:wink:


    Below is the corrected code:



    Hope this will help

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    Or maybe this as an alternative, it will work for change to any cell that affects the value in column AE for that row.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    Hi Carim
    Thank you so much for your perseverance; it's gratifying to have it now working correctly. Could I ask for one final piece of help - I still need to combine it with the coding that capitalizes cell P3 and column X, so that I end up with coding similar to your #15 post.


    Hi KjBox
    In most situations the data is simply entered in a sequence across the row and never altered, however I do have one worksheet where the data is regularly changed and the col AE cell value likewise changes, so your coding will be very useful for that sheet. Could I ask the same of you as I just did of Carim - as with other sheets, that one also has existing event coding that capitalizes cell P3 and column X, as per my post #12. Could you combine your coding and the existing coding into a single block so that both macros will work happily together.


    Again - thank you both.

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    Try this

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    This code would be better

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    If you put this in the ThisWorkbook Object module then it will work for all sheets in your workbook, you do not need any code for the Worksheet_Change Event procedure in any or the individual Worksheet Object modules.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    Fantastic! - you guys ROCK! Carim, KjBox - thank you both for the assistance. I now have worksheets with both the original and the new event coding, and both modules play happily together. Perfect!

  • Re: VBA to Automatically Increase the Last Used Value in a Column


    You're welcome.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!