About Us

Caveman1957

Quote:

Originally Posted by Caveman1957

When in a worksheet I can manually select all cells by doing a control-A is there an equivalent I can use when coding?

I tried recording a macro and it just enters the particular range that was selected so is not dynamic in the way control-A is.

I am trying to do this as a precondition before doing a sort on all the data.

I have come up with this code below but now am having a problem with what to put in the .SetRange to use column A in the UsedRange selection.

ActiveWorkbook.Worksheets("SS").Sort.SortFields.Cl ear
ActiveWorkbook.Worksheets("SS").Sort.SortFields.Ad d Key:=Sheet8.UsedRange, _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("SS").Sort
.SetRange Range(?????????)
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA equivalent for XLL?	Paul Schrum	Excel Programming	1	August 4th 10 10:59 PM
Left() Need the equivalent of this	Presto	Excel Programming	5	December 4th 08 01:40 AM
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does?	StargateFan[_3_]	Excel Programming	10	October 6th 05 01:18 PM
Implant macro coding into ASP coding	Sam yong	Excel Programming	5	September 15th 05 10:37 AM
Equivalent Of VAL	davidm	Excel Programming	4	July 27th 05 06:22 PM

Menu

About Us