Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Formatting Data using a macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steven - 20 Jan 2006 17:00 GMT
lets not hit enter this time!!!

I have a huge dump of data which I'm using a very basic macro to pick
up the columns I need, delete the top two rows and then sort the data
by value.

All this is working well except for the data sort. Anyone any tips?

I'm new to this!!!

Ta.
Yngve - 20 Jan 2006 18:45 GMT
The best way for you to learn something like this (the same as for
everyone
- myself included) is to use the Macro recorder on the Tools...Macros
menu

This is always the best way to start.

Do sorting manual.

When you have finished recording the actions that you need the code
for,
click Stop on the Tools..Macros menu, and use ALT-F8 to show the Macros
dialog.

Select the new macro that you just recorded, and choose 'Edit'

then you can see the code that has been recorded, and this will help
you see
what action you have used, and give you a head start.

Regards Yngve
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.