Posts Tagged ‘routine’

The following routine will sort the sheets in a workbook alphabetically. The flag “Sort_Mode_Descending” can be switched between descending and ascending as required. The routine is case INSENSITIVE. Sub Sort_Sheets() Dim Sort_Mode_Descending As Boolean Dim No_of_Sheets As Integer Dim Outer_Loop As Integer Dim Inner_Loop As Integer No_of_Sheets = Sheets.Count ‘Change Flag As appropriate Sort_Mode_Descending = […]

Wednesday, November 5th, 2008 at 18:21 | 2 comments
Categories: Worksheets

The standard Excel “Column” Function returns the number rather than the letter of the column e.g: Column(E4) – returns the number 5 rather than the letter E Column(AD12) returns the number 30 rather than AD. The following function returns the letter rather than the number of the column. So in the above two examples we […]

Tuesday, November 4th, 2008 at 04:27 | 18 comments