Row numbering macros to renumber rows

Re: Row numbering macros to renumber rows

I am a newbie in VBA. I have a list of scores which have to be graded in nine point scale (ie. A1,A2, B1,B2,C1,C2,D1,D2,E where score <33)

I sort this range and have to grade the first i take the count of the number of failures with less than 33 score then, total_cnt_passed/8 records would give me the count for each of the grades. i have to grade the first n records with A1, but here if the score is 80 at the nth record the next records should also be graded as A1 for all those 80 scorers & so on for the rest of the grades.

i guess, it may be clear.
:?
Plz help, thanx.

Sample table:

Marks Grades
90 A1
89 A1
88 A1
88 A1
86 A1
85 A1
84 A1
82 A1
83 A1
80 A1
80 A1
80 A1
80 A1
80 A1
78 A2
68 A2
57 A2
56 A2
54 A2
54 A2
54 A2
54 A2
46 A2
36 A2
34 B1
33 B1

Re: Row numbering macros to renumber rows

Maxaraxa,

Just select B1:R480 and then File|Print Area|Set Print Area should do it. This will only print this range. If the range changes alot, then we can create some code to do this for you.

Re: Row numbering macros to renumber rows

It is actually a named range now just like any other range. The only way it changes is if you change it. Also, you can have a print area for each sheet. If you have different sections that you print regularly, you can create a macro to set the print area to each section, one at a time, and print each section out.

Glad I was able to help.

Re: Row numbering macros to renumber rows

If all the cells in a column starting from row 6 have data entered you can use this formula at the bottom of the column

=subtotal(3,range:range)

If you use excel 2003 use

=subtotal(103,range:range) allows hidden rows to be excluded from total

Remember to insert rows to move formula down when you need new rows

Say that column A is filled with data from a6 to a500 use formula

=subtotal(3,a6:a500)

This will keep spreadsheet same size

Andy