A personal repository of random information in compensation for a fatigued biological computer
Breaded IT » MS Access / SQL Server reminders » Excel Misc
http://www.contextures.com/excelfiles.html
http://spreadsheetpage.com/
=ISNA(MATCH(C44,Agencies))
Sort named range with column headings:
Sub SortDynaRange()
Range("MyDynaRange").Sort Key1:=Range("MyDynaRange").Cells(2, 1), _
Order1:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
End Sub
Sort named range no column heading
Range("payroll_0430_2_1230").Sort Key1:=Range("payroll_0430_2_1230").Cells(2, 1), _
Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
Refer to named range in VBA:
Application.Names("Basisofrestrictionlookup").RefersToRange