I have an excel files which contains many sheets. for evey sheet, the name is equal to name of student. How Sort worksheets by alphabet using vba Excel? thank you
Hi, This is the syntax to concatenate strings: $text1 = "hello"; $text2 = "world"; $text = $text1 . ' ' . $text2; For your code, use this: function UppercaseText($text_list) { $GlobalText = ""; $TableSize = sizeof($text_list);; for ($i = 0; $i < $TableSize; $i++) { $BigText[] = strtoupper($text_lRead more
Hi,
This is the syntax to concatenate strings:
[crayon-68e6a96ed0f10375986741/]
For your code, use this:
[crayon-68e6a96ed0f15624555786/]
Have a good day
hello, try this code it will help you: Private Sub CommandButton1_Click() Application.ScreenUpdating = False 'disable screen update for performance Dim i, j As Integer Dim SheetsCount As Integer SheetsCount = Sheets.Count For i = 1 To SheetsCount - 1 For j = i + 1 To SheetsCount If Sheets(j).NameRead more
hello,
try this code it will help you:
See less[crayon-68e6a96ed0a2a515449413/]