I wouldn't want Excel to attempt to rewrite any of my code. There
are so many ways to specify a range in VBA that the potential for
error is too high. You can avoid the problem entirely by using
named ranges on your worksheet and using those names in your VBA
code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"badorphan" wrote in
message
...
The way that formulas rewrite themselves when adding rows or
columns so that
they still apply to the right blocks is not true in the case of
macros. While
it is true that the macro is more an external feature, it is
terrible that
the addition of one row or column distorts the application of
the macro to
every row beneath or beyond the insertion. For static workbooks
/ templates
the macro function is essentially worthless and editing them
all for each
addition wastes all the time the macro should be saving. An
internal macro
system just for Excel (the greatest program on Earth) would be
fantastic.

----------------
This post is a suggestion for Microsoft, and Microsoft responds
to the
suggestions with the most votes. To vote for this suggestion,
click the "I
Agree" button in the message pane. If you do not see the
button, follow this
link to open the suggestion in the Microsoft Web-based
Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming