macro ascending/descending

[max_max]

Hello to all.
I ask to help to understand why the macro does not report the value in descending into row 2.
I am attaching an example.
max max

[nilem]

maybe so

Please Login or Register  to view this content.

[Bernie Deitrick]

The macro works perfectly, but your 'blank' cells are not really blank. So, first, sort using your ascending macro, scroll down to the first 'blank' cell in column C, then delete everything from there down, and your macros will work the way you expect them to.

[max_max]

Thanks nilem I think it works well.

Bernie Deitrick i know that empty cells are not quite empty but there is
the formulas and then for the macro it is as if they were empty.

Greetings from Italy at all.
max_max

[Bernie Deitrick]

Then just be aware that converting to values removes the formulas permanently.

[max_max]

Ah that's why I can not see the formulas
I thought it was me.
Then the macro nilem does not work perfectly.
max_max

[Bernie Deitrick]

The solution depends on what you are doing with the other columns, and whether they are constants or formulas - I think code like this will work for all cases:

Please Login or Register  to view this content.

[max_max]

Thanks Bernie,
I think it's perfect.
It also works with formulas.
Tomorrow I try it in my office.
A greeting and thanks again.
max_max

[max_max]

Bernie curiosity:
if the sheet there are other columns as last column is H here:

lngR = Application.Evaluate ("SUMPRODUCT((LEN(C1:C15000)>0)*1)")

I have to change in H?
max_max

[Bernie Deitrick]

Change it to the column that you are actually sorting on - if that is H:

Please Login or Register  to view this content.

[max_max]

O.k. bernie
thank you again
max_max

[max_max]

Thanks Bernie,
I tried the macro in my office and it works well.
Thanks again.
max_max