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