VBA Example: Sort Array Function

preview_player
Показать описание
  1. LearnChemE
  2. chemical engineering
  3. screencasts
  4. engineering
  5. learncheme
  6. bubble sort
Рекомендации по теме
VBA Example: Sort 0:07:46

VBA Example: Sort Array Function

VBA Array with 0:15:55

VBA Array with Filter, Sort and Slice (2021)

Mastering the VBA 0:01:45

Mastering the VBA Array Sort Function

Excel Macro - 0:05:02

Excel Macro - Sort Data, Dynamic Range - Excel VBA Part 12

Sorting with Excel 0:09:08

Sorting with Excel VBA

VBA to Sort 0:07:57

VBA to Sort Data in Excel - Excel VBA Tutorial

Excel VBA Sort 0:04:39

Excel VBA Sort Multiple Columns

Excel: SORT Function 0:05:19

Excel: SORT Function - New Dynamic Array Function by Chris Menard

Excel VBA: How 0:08:37

Excel VBA: How to Sort Data with VBA Macro

HOW TO SORT 0:16:18

HOW TO SORT VALUES INSIDE AN VBA ARRAY - HELPFUL IN PROJECTS

VBA Arrays Explained 0:03:44

VBA Arrays Explained in 3 Minutes

VBA Sorting items 0:07:00

VBA Sorting items in an Array

Excel VBA Arrays, 0:27:24

Excel VBA Arrays, Resize (ReDim, Preserve) Arrays, Create Functions That Return Dynamic Arrays

Excel Sorting Showdown: 0:07:40

Excel Sorting Showdown: VBA Sort - Episode 2093

How to Use 0:10:20

How to Use Arrays Instead of Ranges in Excel VBA

Arrays and Functions 0:06:46

Arrays and Functions in Excel VBA

Excel Dynamic Arrays 0:07:01

Excel Dynamic Arrays (How they will change EVERYTHING!)

Array : Sort 0:01:31

Array : Sort 2D array in Excel VBA

VBA Arraylist - 0:02:19

VBA Arraylist - Sort Function - Range/ array and cell/string sort - Excel Cell by Cell

Excel VBA - 0:02:40

Excel VBA - Array Function

Excel VBA Tutorial 0:07:54

Excel VBA Tutorial | Sorting data in excel using vba

Excel VBA to 0:02:43

Excel VBA to Sort Column in Table

VBA Example: Diagonals 0:03:49

VBA Example: Diagonals Array Function

VBA Subs and 0:09:45

VBA Subs and Functions with Arrays

Комментарии
Автор

Function SortVector(rng As Range)
Dim i As Integer, j As Integer, n As Integer
Dim Temp As Integer, A()
n = rng.Rows.Count
ReDim A(n, 1)
A = rng

For i = 2 To n
For j = 2 To n
If A(j - 1, 1) > A(j, 1) Then
Temp = A(j, 1)
A(j, 1) = A(j - 1, 1)
A(j - 1, 1) = Temp
End If
Next j
Next i
SortVector = A

End Function

amogussiiuuu
Автор

This is awesome! I modified to change order i.e. ascending/descending with optional parameter. Learned a lot! Thanks for sharing :)) Thumbs up!!

wayneedmondson
Автор

this quite a bit simillar to my project however does your code sir works for sorting letters?

edtardaguila
Автор

hi, its better late than never, may I ask why is it 2 to n, why it started in 2, not 1? noob here, I know I have to start in 1, but in here, it started on 2, please teach me a bit. thank you.

arielzabatecuizon