View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
badorphan badorphan is offline
external usenet poster
 
Posts: 3
Default Excel should rewrite macros when adding rows or columns

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