Dave

Thank You, I am starting a collection of notes.

Nancy X.

"Dave Peterson" wrote:

Yes. You can look at cells that are in columns that are hidden or in cells that
in rows that are hidden.

You can also refer to those hidden cells in formulas in the worksheet, too.

And if you need to look at those cells in your code, make sure you do all your
processing before you delete any rows or columns (if you decide you want to
delete stuff).

Nancy X wrote:

Dave;
If I hide a column can I still look in that column with a Macro.
What a student does in certain classes also determines what tests the student
should take and if the student should be in Literature or Advanced
Composition as an example. I want to plan my attack before I try to start
writing code, script, etc.

Thanks Again

Mrs X

"Dave Peterson" wrote:

I'd keep all the data where it is.

But learn how to hide the columns you don't want. You could do this in a macro
in a different workbook if you can't update that original workbook.

Then learn about Data|Filter|autofilter.

You'll be able to hide rows you don't want to see. Here's hoping that you have
a field that is used to indicate whether the students are eligible.

By keeping the data in one location, you'll always know that you're working with
accurate data. A big problem if you create your own copy of the data.

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.

--

Dave Peterson


--

Dave Peterson