Find last values in multiple rows.

    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