Replies

So i’m not alone..hehe..(completely in the dark )

Anyway..thanks hans for the effort

I really hope somebody can help me solve this saga..

So i’m not alone..hehe..(completely in the dark )

Anyway..thanks hans for the effort

I really hope somebody can help me solve this saga..

Thanks again Hans for the response….

To answer your question , ia have to attach another wb in order to make you understand what

am i doing with those 0 value..please refer to my attachment..thanks

(Edited by HansV to make URL clickable – see Help 19)

For reference , this is my post about this thing a couple weeks ago and have been solved by steve and andrew

But it occured again when i expand my range and do it in a new sheet..Any ideas ? Thanks

Below is the link to my question :
post 364542

Thanks Hans for the answer..

But what FYI , the real database is , i copy that data from other sheet and paste it using

paste special into the seet that i senta as an attachment

I know about that zero value because it is my intention to hide it..

But 2 weeks ago steve have give me a code to sort between negative numbers and positive numbers

it works fine.. The code is :

Sub GlobalSusunGred()
Sheets(“GlobalKelas”).Activate
Dim strPwd As String
strPwd = “”

Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:=strPwd
Sheets(“GlobalKelas”).Select
Range(Range(“AH6”), Range(“B65536”).End(xlUp)).Select

ActiveSheet.Unprotect Password:=strPwd
Selection.Sort Key1:=Range(“ah6”), Order1:=xlDescending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Sheets(“GlobalKelas”).Select
Range(“b7”).Select

Application.ScreenUpdating = True

End Sub

it works fine with that range and that sheet..with above code , i manage to sort range B7:AH48 easily
and without any problem

But when i expand my range to B7:AH216 and using other sheet , its not working

I feel very weird..thanks..

Thanks Hans for the answer..

But what FYI , the real database is , i copy that data from other sheet and paste it using

paste special into the seet that i senta as an attachment

I know about that zero value because it is my intention to hide it..

But 2 weeks ago steve have give me a code to sort between negative numbers and positive numbers

it works fine.. The code is :

Sub GlobalSusunGred()
Sheets(“GlobalKelas”).Activate
Dim strPwd As String
strPwd = “”

Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:=strPwd
Sheets(“GlobalKelas”).Select
Range(Range(“AH6”), Range(“B65536”).End(xlUp)).Select

ActiveSheet.Unprotect Password:=strPwd
Selection.Sort Key1:=Range(“ah6”), Order1:=xlDescending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Sheets(“GlobalKelas”).Select
Range(“b7”).Select

Application.ScreenUpdating = True

End Sub

it works fine with that range and that sheet..with above code , i manage to sort range B7:AH48 easily
and without any problem

But when i expand my range to B7:AH216 and using other sheet , its not working

I feel very weird..thanks..

Thanks Hans…it works like a charm

Thanks Hans…it works like a charm

If you still stuck , just upload your file here. If it is too big , you can email me..I will open it for you.FOC lol

If you still stuck , just upload your file here. If it is too big , you can email me..I will open it for you.FOC lol

Hiii back andrew..its been quite sometime since i come here..

thanks andrew..the code works like charm..:-))

Hiii back andrew..its been quite sometime since i come here..

thanks andrew..the code works like charm..:-))

Thanks to you guys both..sdckapr and TonyJollans ..

So far so good..but I’ve still not tested it with multiple condition yet..

If any problem occured again..I will post again..cheers

Thanks to you guys both..sdckapr and TonyJollans ..

So far so good..but I’ve still not tested it with multiple condition yet..

If any problem occured again..I will post again..cheers

Hi,

just want to help. if u still cant recover the pw for your wb, just sent your wb to me as long its not contains the pw that come with the save as-options-general, i will surely can recover your pw.cheers. sent your mail to : boymoi@yahoo.com

ps: if it contains vba project also, i can recover the pw..