Last row of same character

[KBSH]

Im trying to find the code for the next example:

On the picture in column "A" there are several characters wich are the same. The code should be able to select all rows with that same character and observer that it's continuously. So the rows containing an "x" in the red zone should not be selected.
Knipsel.JPG

[KBSH]

Something like:

Please Login or Register  to view this content.

won't work

Something like

Please Login or Register  to view this content.

does seem to work, though I need a small adjustment on this code that selects not only the last cell, but the other ones aswell.

[sysss]

Hello friend,

this my first post actually... my first try of code posting here. So hello KBHS & everyone..

Looking at it now seems my code a bit complicated then your examples. It is a pure loop of each cell and comparing its values.

Try this if it can help you in some way...

Please Login or Register  to view this content.

Thanks
sysss

[stnkynts]

Try this

Please Login or Register  to view this content.

[amartinez988]

Check if you can get something out of this

Please Login or Register  to view this content.

[amartinez988]

stnkynts,

Using areas is a great and fast solution.

Thanks for the option

[Winon]

Hello sysss,

Welcome to the Forum.

I think your Code is great! With a few changes it now works like this:

Please Login or Register  to view this content.

Regards.

[stnkynts]

stnkynts,

Using areas is a great and fast solution.

Thanks for the option

Welcome. Thanks for the rep .

[sysss]

Hello Winon,

and thank you very much. This is really nice place to learn.
I like your changes and the other solutions as well.

Have a good day
sysss

[jindon]

Different method.

Please Login or Register  to view this content.

[KBSH]

Thanks people for the great help!

[amartinez988]

Great!

Please don't forget to mark the post as SOLVED and add reputation to members that helped you.

Thanks,

[KBSH]

Hello sysss,

Welcome to the Forum.

I think your Code is great! With a few changes it now works like this:

Please Login or Register  to view this content.

Regards.

This code does exactly what it needs to do!! However it's a bit complex and I would like it to be very simplified (no msgboxes and stuff) and I would like the code to be concerning only about a continuous range beside a cell. I want to make a sheet like the one in the attachment that contains rows that can be moved upwards or downwards by the push of a button. I know it will be hard, but I'll try to do it myself, but it would be nice if someone could help me with this. I'm already experimenting with spinbuttons. The code doesn't need to be working with colors btw.

[KBSH]

For the starting position of the continuous range I'm thinking about something like:

Please Login or Register  to view this content.

Edit:

Please Login or Register  to view this content.

Edit 2:

Please Login or Register  to view this content.

This code doesn't work....

Sorry if I wasn't clear on what I wanted

[Winon]

Hi KBSH,

Thank you for the feedback.

Your sample workbook with all the Buttons, somehow made me believe we might be looking at fixed Ranges, but then again I think, just maybe you are over complicating things a little bit.

To illustrate my point, please try the "Try Me !" Button on the attached sample Workbook.

Regards.

[KBSH]

Thanks for your input....we are getting close. I'll upload a very simplified and halfway translated version of what I'm working on, so you'll understand what my problem is.

Just push on the buttons and you will see what happens..... I want the inserted ranges to be portable....I've already made them expandable.

I've quickly altered the code in that attachement so it's possible that some stuff doesn't work the way it should work.

I don't think that I'm overcomplicating things...this really is a challange.

Edit: attachement removed

[KBSH]

Please Login or Register  to view this content.

is the code that I think has to be used for the newly created buttons or in my case

Please Login or Register  to view this content.

In your code the buttons get named....that would not be possible in my case.

[Winon]

Hi KBSH,

Hokaai, komen we nemen het stap voor stap. Is de laatste Workbook wat ik voor u gezonden heeft, recht voor je?

Your newly uploaded Workbook appears to be a major deviation from your original issue.

Please could you confirm that your original issue has been addressed or solved.

Ik ga nu eerst slapen, en zal more weer met je praten.

Groete.

[KBSH]

Haha

I wanted to solve the problem myself so I only posted small parts of my entire problem. As I'm not that advanced with VBA yet and only able to alter codes instead of making them, this is a huge challenge for me. I don't even know whether it's even possible to do what I want.

I really appreciate your help though.

Sleep well

I'll upload an even more simplified version so stuff doesn't distract from the real problem.

[Winon]

Hi KBSH,

Post No. 18 refers.

I am still awaiting you reply to:

Please could you confirm that your original issue has been addressed or solved.

Regards.

[KBSH]

Hey

Yeah I guess you're right. When I'm at home I will open a new thread. I will mark this as solved.