Microsoft Office Tutorials and References
In Depth Information
CREATE WORKSHEET NAMES BY USING THE FILL HANDLE
Cells(1, 1).NumberFormat because in most cases, typing the value
causes Excel to change the number format.
As a compromise, the macro types the worksheet name preceded by an
apostrophe. This allows 9-15 and Sep 15 entries to work through the end of
the month. Note that these text entries work just like Room 101 works in the ﬁ ll
handle. Sep 15 accurately jumps to Sep 16 , but Jan 31 inaccurately jumps
to Jan 32 ! Figure 135 shows several examples of workbooks where the ﬁ rst
worksheet was copied using the macro in this chapter.
Figure 135. h e macro correctly handles
many items but fails when extending Apr 30.
Tip: If you deﬁ ne a custom list, you can have this macro use the names in the
Summary: Perhaps Microsoft will add this functionality to a future version of
Excel. Until it does, use this macro to copy worksheets and change their names
to a known series.