Sorting VBA?

  • Thread starter Thread starter TyeJae
  • Start date Start date
T

TyeJae

Is there a way to sort using VBA code, I know how to do it by building
simple macro, but I want to try it with VBA.

Thanks,
TyeJa
 
When you do a "simple macro" you are using VBA so your problem is solved
 
Hi TyeJae

There are many algorithms for sorting in VB / VBA. Question is: Sort what ?

Best wishes Harald
 
The simple macro is VBA!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I have a form that has a From (this Date) to (this Date) Search box.
After the person selects what dates they want to search from and pus
the Search button, I want to sort 2 columns of data decending. Thank
for your help.

TyeJa
 
when you sort columns it sorts all the data not just the data tha
matches a date.

Are you sure you need to sort it sounds more like you want to displa
data that falls inbetween a start & end date. If this is correct yo
probally need to use Auto filter or sort then auto filte
 
Hi TyeJae

Second the others then: Record a macro and you're done. Look also into
Autofilter for hiding dates outside the interval.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort partially hidden data 1
Macro that will insert a simple text string in top cell of text file 1
Problem sorting a range of columns using VBA 1
Format change with VBA language dependent? 5
Sort The Date at the center of string with VBA 1
VBA and SOAP in Excel 2010 0
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Knowing is a workbook's VBA project has password or not 2

Back
Top