Scris: Vin Oct 14, 2005 12:46 pm
voinice, asta numa daca ramai matale in div B
Fanclub Forum - Locul de intalnire al fanilor
http://forum.fanclub.ro/
RooT scrie:Nu m-am prins cum se copiaza din clasamentul intermediar in cel general asa ca am dat-o pe manual ... daca shtitzi cum .. let me know ...
h0va scrie:activeaza macrourile
Sub clasament()
'
' clasament Macro
' Macro recorded 03.06.2005 by dude
'
' Keyboard Shortcut: Ctrl+s
'
Range("J31:R40").Select
Selection.Copy
ActiveWindow.SmallScroll Down:=-8
Range("J3:R12").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("J2:R12").Select
Range("R2").Activate
Application.CutCopyMode = False
Selection.Sort Key1:=Range("R3"), Order1:=xlDescending, Key2:=Range("Q3") _
, Order2:=xlDescending, Key3:=Range("K3"), Order3:=xlDescending, Header _
:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom _
, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _
xlSortNormal
Range("A1:D1").Select
End Sub
tur: gigiell - baixinho © 3-3
retur: baixinho © - gigiell 3-3