| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highest sheet name
hi,
lets say i have a number of sheets, with names like acct1, acct2, acct3, acct4 and so forth. how can i determine the largest of the name? like from the above, acct4 is the largest. thanks in advance, geebee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
highest sheet name
highnum = 0
For Each sht In ThisWorkbook.Sheets If Left(sht.Name, 4) = "acct" Then newhighnum = Val(Mid(sht.Name, 5)) If newhighnum highnum Then highnum = newhighnum End If End If Next sht "geebee" wrote: hi, lets say i have a number of sheets, with names like acct1, acct2, acct3, acct4 and so forth. how can i determine the largest of the name? like from the above, acct4 is the largest. thanks in advance, geebee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Next highest Value | Excel Worksheet Functions | |||
| Highest, Second Highest , Third Highest and so on | Excel Discussion (Misc queries) | |||
| Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| Formatting the 5 highest values in a range, and copying them to another sheet | Excel Programming | |||
Linear Mode
