[mso] Re: Named Ranges in Word?...nope (was Are Office newbies intimidated by this group?)
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 22 Sep 2003 19:45:40 -0400
Well, VBA would certainly automate this and I'm sure Dian can tell you the
code to use..but if you want to do it manually, why not just sort your table
by Last Name, then First Name...that would put all of the ones that are the
same together, then you could just copy/paste that group of table cells to a
new page
Yes, Dian, I know this is the slow non-VBA way, but if someone really
doesn't want to use VBA, this is the ol' manual workaround LOL
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Robert Carneal
Sent: Monday, September 22, 2003 7:22 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Named Ranges in Word?...nope (was Are Office newbies
intimidated by this group?)
<Copy>
No Robert...Word tables do not have the Named Range feature that Excel has.
Maybe if you tell us what you want to do, someone can suggest an
alternative? (probably will be VBA tho, I betcha LOL)
<End>
VBA? Ulk, not ready for that. I bet you are right though.
What I have is a LONG table (it spans about 90 pages), and five columns.
First column is the last name of a person, the second column is the first
name (or first and middle names, if the middle name is known), and I have
looked for a to say something like:
Search for LastName= CYAN and FirstName contains James.
I would want it to make a new table on a new page containing the names of
those people.
Oh well, I will learn macros from one of you next term.
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
*************************************************************
Other related posts:
