Lisa
I have looked through the data file you posted including the VBA-Code
I have a whole new thought on what you have been discussing and why you are
having problems with proposed solutions.
1) You are NOT talking about sorting the data on the excel sheets
2) You are doing maintenance on VBA modules and procedures and need to
extract and sort various information.
a. Your current code is sorting statements such as
i. Dim
var2 as variant
ii. Dim
var1 as variant
Into order.
b. Thus data you are sorting is always "intermediate" and never on a
sheet.
Is this what you want to discuss ?
db
[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
----------------------------------
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
----------------------------------
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar