Data sort, empty formula cells to bottom merged cells!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Hi,

But if I do descending its goes from Z->A and not from A-> Z


thanks for your time

greetz
ikkuh


ps: Sorry zbor forgotten

Then edit post please if forgot.

hi,

it indeed does but, I need to make that into a button and that doesn't work =/

but thanks


greetz
ikkuh

Hi,

It gives an error in: error 424 no object

Please Login or Register  to view this content.

hi,

I tryed that but then the line turns red =/
and gives "syntaxis error"

:/

Hi,

Here you can find a look a like file
as you can see the rows need to stay together

thanks your time!

greetz
ikkuh

Hi,

I indeed noticed before that I had some problems that should not be there cuz of the merged cells =/
Is there a way to do it with the merged cells?
Or do I need to change it? =/

thanks!

Hi,

I still didn't manage to find this out =/
any suggestions??

thanks in advance!

Hi,

Is it possible to sort these merged "empty" (they contain a formula with gives a "0" (formula: ='blad3'!B7.......='blad3'!B81)) cells.
Already spend a few days on this problem =/ can some one plz help??

Thanks in advance!

Very helpful information, worth reading this forum, good work guys, i learnt some new techniques.