sort ascending order

I need something like this:

Please Login or Register  to view this content.

but without ".Select". If I use "Select" this will not work:

Please Login or Register  to view this content.

it's not working, thanks anyway

I have this error if I use the above code:
"Run-time error'1004'
The sort reference is not valid . Make sure it's within the data you
want to sort, and the first Sort By isn't the same or blank"

I found some documentation here about my question:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

The code posted by "shg" should work but I don't know why it doesn't.
I have 1004 error.
Please help!

My second problem ("Also I need in column G only the values without formula") is solved with the help of this forum user . I added gren code.
My code looks like this now:

Please Login or Register  to view this content.

Now I only need to add some code that will sort ascending the value from column F. In column "F" I have only numbers.
Thank you!

This code will sort ascending also the formatting of the cells from column D, I need only the values to be sorted starting from row 3.
In column D all cell are gray or yellow, if I run the macro, in column "D" I will have cell with the value, colored.

If I use this code:

Please Login or Register  to view this content.

it will work but,
I need Column F and G starting with row 3.
I need range "F1:G2" not to be affected!
Please open attached file!
I posted this question also on my other thread, sorry for that!

Only one problem, I have in range "G11" value 0, I don't need that value!
Please open attached file!
Thank you for your time!

Please Login or Register  to view this content.

I have 2 more question:

1.It's nor possible to modiy the code so we don't need the red code (from above) ?

2.It's nor possible to use this code (Multiply and count_unique) with:

Please Login or Register  to view this content.

??
Now the macro run for each "selection" but I would like to run for each "change"!

Thread solved
Thank you!