Macro to increase data range

Giganews Newsgroups
Subject: Macro to increase data range
Posted by:  H.Schurch (aussieha…@iprimus.com.au)
Date: Thu, 9 Oct 2003

Dear Excel Enthusiasts

Unfortunately I have no knowledge of VBA. I would like to create a Command
or Macro button that would add a new row to a range of data, and one button
that would remove a row from a range when it is clicked

I have data in 25 rows at the moment, the populated range starts at cell A3
and the last populated cell is R25.  Cell A25 has a label called "TOTAL". In
that row all the data from row 3 to row 24 is summed up. The number of rows
can change but will never be more than 200. I would like a Macro that would
copy the formulas and formatting of the row above the  "TOTAL" row, copy it,
insert a new row and paste it to the new row.  This way if more rows are
needed I can just increase the data range  with aclick of a button.

The "Remove Macro" should do the opposite.

Any Help is greatly appreciated

Replies