|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 14th, 2002, 06:35 AM
|
#1 |
|
New Member
Join Date: May 2002
Location: Jerusalem, Israel
Posts: 7
|
Hey people thanks for your previous help!
I have another question How do i sort with VBA? Let's say i have A-D columns with a header row 1,2,3,4 how do i sort by header "1" descending, and header "3"? Thanks! Gil |
|
|
|
May 14th, 2002, 06:49 AM
|
#2 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Auckland, New Zealand
Posts: 4,209
|
Quote:
Turn your macro recorder on > do your steps Stop recording and see what you get. If you have further problems then post...
__________________
Kind Regards, Ivan F Moala From the City of Sails 
|
|
|
|
|
|
May 14th, 2002, 07:00 AM
|
#3 |
|
New Member
Join Date: May 2002
Location: Jerusalem, Israel
Posts: 7
|
Hey Ivan,
Never worked with macro recorder. I'm doing it thru user form. I have few listboxes there and when i press some value at one of them the program automatically sorts the database and shows to me all the records with the value. Thanks, Gil |
|
|
|
|
May 14th, 2002, 09:24 AM
|
#4 |
|
New Member
Join Date: May 2002
Location: Jerusalem, Israel
Posts: 7
|
Ivan hey (again)
I have finally tried the macro recorder, untill now i prefered just to put some of mine lines of codes... It works very nice! solved all my problems after i decoded it. Thanks! Gil |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
