I am using Excel 2010 on a Win7 machine.
I have a macro that will prompt the user to select a cell.
Then the macro will select that entire row.
Then another prompt will ask the user how many rows they want copied.
Then it will copy that row selected and insert how ever many rows the user prompted on No. 3 above.
What I need:
A way to instantly change the pasted values in one cell/coloumn of each newly pasted row..
I can't seem to figure out how to select the rows I inserted (based on user input) to change the value automatically.. since the active cell will change often, I can't do it based on a range.. it has to be whatever rows were inserted by the user prompt..
i.e.
1.1.1.1 I0127955 29.4 m
10.1.1.1 TAG-01 12 m
User selects I0127955 and then the row is copied via macro. And then new rows are inserted via user input (in example below userinput = 2) and then the data becomes this with macro:
1.1.1.1 I0127955 29.4 m
1.1.1.1 I0127955 29.4 m
1.1.1.1 I0127955 29.4 m
10.1.1.1 TAG-01 12 m
I need it to become this:
1.1.1.1 I0127955 29.4 m
new I0127955 29.4 m
new I0127955 29.4 m
10.1.1.1 TAG-01 12 m
Here is my new and improved code!
I can't figure out how to define the selection without a range..Please Login or Register to view this content.
Thanks for any help, everyone
Bookmarks