Based on your statement "never written a macro before" I would recommend ISBN
0-7645-3758-X "Excel 2003 All-In-One Desk Reference for Dummies" by Greg
Harvey. Make sure you get that one - there's another by same author, similar
title but with less info in it. This one is a "9 books in 1" deal and
besides all the basics of Excel, it has a section specifically about Excel
and VBA.

Another that may be useful later as you get more familiar with macros and
VBA in general may be ISBN 0-7645-3263-4: "Excel 2000 Power Programming with
VBA" by John Walkenbach. There's probably a 2003 version out, but I have the
2000 here and it still serves the need.

Once you become familiar with setting up variables to reference the objects
(worksheets, cells, etc) in Excel you will find that you can often figure out
how to get a job done in code by first recording a macro to do that type of
operation so that you can see the Excel objects referenced and the properties
and methods used to get the job done in a fixed manner. Then you can modify
the recorded macro to add looping and change fixed references to ones that
will change as needed to get the 'custom' macro needed to meet your
requirement.

"Nancy X" wrote:

Tom;

I am sure if I ever get this to work (our programming staff does not
want to mess with it) that the rest of the teachers will want to use it. I
want to keep it as easy as possible.

The WorkBook is so large it took me between 1.5 and 2.0 hours just
for my 4th period class.

Is there a book you can recommend before I take this on?

Thanks

Mrs X


"Tom Ogilvy" wrote:

Why not just copy the workbook. Select the entire columns you want to delete
and do Edit=Delete. You can select entire columns by clicking at the top of
the column. You can use the control key with the mouse to select
non-contiguous columns.

After you get down to the columns you want, then start working on the rows
in a similar fashion.

--
Regards,
Tom Ogilvy


"Nancy X" wrote:

I am an English Teacher at a Gates Foundation High School.

I have never written a Macro Before and I need an opinion. The WooKBook
that we have set up is the largest I have ever seen.

I want to reduce it in size and cut the columns down for just just what we
need in English.

We have 51 columns that pertain to different English Classes. I just want
the ones that pertain to what I teach, but the math formula for that is very
complex.

I also want to remove the students that are not eligible for certain classes.

Any recommendations as to the best way to do this?

Thank You Very Much

Mrs X.