Print a Excel2007 worksheet using the macro reverse order

In the book or the novel print, you do not set reverse order printing, then the paper will need to be rearranged, because the first page is placed in the bottom, many words obviously not that time to another one of the tune. Here's how to use the macro method to solve Excel table in reverse order printing.

Start the Excel table and click View-Macro-to record the macro.

Figure 1

Macro name can be arbitrarily set, but for the formal, generally used in English nomenclature, Reverseprint.

Figure 2

After naming, return to the main interface, press ALT+F8 shortcut key to open the macro management interface, select Reverseprint, click the Edit button.

Figure 3

Below, I use my previous programming experience, provide everybody the following code, everybody only need to replace the original code.

Figure 4