Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help Selecting, Sorting, Autofitting a range
Set rng = NwSht.Range("A1:G8", NwSht.Range("G65536").End(xlUp)).Select
rng.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom rng.Columns.AutoFit NwSht.Range("A1").Select NwSht.Activate Not working, what am I doing wrong? says object required on the first line above. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and Selecting dates | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Jim Rech's macro won't work (autofitting merged cells) | Excel Discussion (Misc queries) | |||
linked cell contents not autofitting row height | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) |