Find last values in multiple rows.

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Thanks a lot for your Thanks to rollis13 ... :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Well, I can still say it's not perfect. If column AY has data the macro won't work as required. This is how it should be (final :P) :

    Range("BB" & x) = Cells(x, 52).End(xlToLeft).Value

    By the way, I completely missed this statement: "Aim is to return value of the last cell of each row " in your post #1:sleeping:.


    I'm glad I've been of some help:thumbup:.

    Quote from rollis13

    Well, I can still say it's not perfect. If column AY has data the macro won't work as required. This is how it should be (final :P) :

    Range("BB" & x) = Cells(x, 52).End(xlToLeft).Value

    By the way, I completely missed this statement: "Aim is to return value of the last cell of each row " in your post #1:sleeping:.


    I'm glad I've been of some help:thumbup:.

    Thanks very much rollis13.

    I've already realized that 51/52 is an empty column number from which to start countdown to the left, depending of the length of the rows. I understand that should the length of the rows increase I would have to move data from column BB to the right.

    Thanks again for your help.

    Dilshod

Participate now!

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

Register Yourself Login