Yes!!!!!!!
-----Original Message-----
From: David Braithwaite <dbraithwaite@charter.net>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Sat, Jan 7, 2012 9:25 pm
Subject: Re: [ExcelVBA] Re: Sorting in VBA
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
aving 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
xtract and sort various information.
a. Your current code is sorting statements such as
i. Dim
ar2 as variant
ii. Dim
ar1 as variant
Into order.
b. Thus data you are sorting is always "intermediate" and never on a
heet.
Is this what you want to discuss ?
db
[Non-text portions of this message have been removed]
------------------------------------
----------------------------------
e sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here:
ttp://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES
or EXCEL VBA.
----------------------------------
isit our ExcelVBA group home page for more info and support files:
ttp://groups.yahoo.com/group/ExcelVBA
----------------------------------
ore free tutorials and resources available at:
ttp://www.mousetrax.com
----------------------------------Yahoo! Groups Links
Individual Email | Traditional
http://docs.yahoo.com/info/terms/
[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