Hi pynasocas
One of the aims of the project is to be application independent.... meaning not using a worksheet in excel or a database in access.
Lisa
-----Original Message-----
From: PY & Associates <pynasocas@yahoo.com.sg>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Sun, Jan 8, 2012 2:30 am
Subject: Re: [ExcelVBA] Re: Sorting in VBA
Can you consider this air code:
if sheet("Sort").exist thensheet("Sort").delete
orksheets.add
activesheet.name="Sort"
opy original table to sheet("Sort")
ith sheet("Sort")
.range.sort keys1:=9, keys2=6, keys3:=4
.range.sort keys1:=1
nd with
rray=sheet("Sort").range
sheet("Sort").delete
Sort in reverse order IS the key.
Regards
C@103
ynasocas
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar