I'm attempting create a macro that will add a new line below the line in which the user is, copies all data and formulas from the line above, except for columns G and H. Ends in Column G, ready for editing. I came up the macro below, which does what I want, if you are in row 3, but how do I generalize it.
Another way to ask the question, how do I change the reference
Rows("4:4").Select
to something that means select the row below the one I'm in. e.g.
Rows("the-one-I'm-in+1").Select
Any help appreciated.
JensPeter
Bookmarks