[mso] Re: Would like to study example
- From: "Ray Blake" <ray@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 12 Oct 2003 09:47:44 +0100
Robert,
Yes, I've done this quite recently. A couple of pointers for you:
1. Finding the insertion point at the bottom of a list. Assuming the
list is a standard data table, you can find the first blank cell after
its end like this:
Range("a1").CurrentRegion.End(xlDown).Offset(1,0).Select
2. The sort element should be pretty straightforward. Recording a macro
using the recorder is the easiest way to do it. Select a1, go to the
Sort menu command and do what you need to. Then edit the macro. Two
words of warning here: (a) lose most of the optional sort arguments that
the recorder appends to the sort command, because some of these aren't
compatible with earlier Excel versions and aren't really needed for a
straightforward sort of the kind you describe; (b) replace any 'guess'
argument on the header line property with a yes or no as appropriate.
Good luck.
Ray
_____________
This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.
For more information on the services that we offer please visit us at
our website: - www.grbps.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Robert Carneal
Sent: 11 October 2003 22:45
To: mso@xxxxxxxxxxxxx
Subject: [mso] Would like to study example
Does anyone know of an example that allows the user to enter 8 fields,
and
when done does the following:
1. Add to the bottom of the spread sheet.
2. Re-sort the list based on Column B and then Column F automatically?
I -think- I can very rudimentarily make a form in Excel, but the
information entered doesn't get saved where I thought it would. It's my
first form and I am sure I am error-ridden with it.
Thank you.
Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
