Problems with my macro to sort. It is bringing blank rows to the top.

[ricdamiani]

Hi guys,

I recorded the following macro:

Please Login or Register  to view this content.

There is a problem in the range here I think.
What is happening is if there is a blank cell between that range, when it is sorted, it brings the blank rows to the top.

So the GOAL of the macro is to find the last cell with data in the column (in this example column G), select all the cells from the last to the top (to G4), and then sort it out.
You can find a sample sheet attached explaining very well:
sample 20-08.xlsm

Something I cannot understand as well is some cells are not being sorted very well. You can find for example, after sorted, the cells with WHITE written on them, not together with the group of white. Any idea why it happens?

Thanks folks

[ricdamiani]

Hi guys

Anybody can help on that?
Sounds pretty simple

Thank you!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[ragulduy]

You can find the last row with data using:

Please Login or Register  to view this content.

so your sort would become

Please Login or Register  to view this content.

Edit: @ John, that works providing the data always starts in row 1...

[JOHN H. DAVIS]

You can find the last row with data using:

Please Login or Register  to view this content.

so your sort would become

Please Login or Register  to view this content.

Edit: @ John, that works providing the data always starts in row 1...

You're right yudlugar. Good catch. Can be modified:

Please Login or Register  to view this content.

[ragulduy]

Yeah, I think JosephP explained it to me at one point, I think it can be further modified to something like:

Please Login or Register  to view this content.

but then you could probably use

Please Login or Register  to view this content.

I think there is a reason/certain circumstances where those methods don't always work though.