Upload

Loading...

Excel 2007 - Macro para função Classificar{www.zipteck.br.ms}

13,813 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Jun 21, 2010

Video explicando como deixar a função SORT ou CLASSIFICAR automatica.

Codigo da macro:




Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Worksheets(1).Range("b2:d500"), Target) Is Nothing) Then DoSort End If
End Sub

Private Sub DoSort() Worksheets(1).Range("f2:g4").Sort Key1:=Worksheets(1).Range("g2"), Order1:=xlDescending

End Sub

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...