| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need help Selecting, Sorting, Autofitting a range
Get rid of the .Select at the end of the first line of code.
E.g., Set rng = NwSht.Range("A1:G8", NwSht.Range("G65536").End(xlUp)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mr. Clean" wrote in message om... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need help Selecting, Sorting, Autofitting a range
Also
Key1:=Range("A2"), should be Key1:=NwSht.Range("A2"), -- Regards, Tom Ogilvy Chip Pearson wrote in message ... Get rid of the .Select at the end of the first line of code. E.g., Set rng = NwSht.Range("A1:G8", NwSht.Range("G65536").End(xlUp)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mr. Clean" wrote in message om... 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. |
| Reply |
| 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) | |||
![Mr. Clean[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
