Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
functions
from the little bit of programming i have taken, i know you can combine
similar codes using functions. can someone help me with these sets of code i have? Sub SortProjectName() ActiveSheet.Cells.ClearOutline Range("A6:T1112").Sort Key1:=Range("Q7"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub Sub SortDateRec() ActiveSheet.Cells.ClearOutline Range("A6:T1112").Sort Key1:=Range("T7"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Public Functions As Worksheet Available Functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |